Why does substring take smaller size than specified

[mariayx]

I use SUBSTRING(@data_string, 12, 17) to get a substring from the following whole string '140PTOHCO 2DTT707904 CCONTINENTAL AIRLINES 460120030822 N'
But instead of getting '2DTT707904', I got only '2DTT707'. Can someone help?
Thanks,
mariayx

 

[JayKusch]

Maybe the variable you are using to hold the new substring element is not define to 12 characters ... try this ...

declare @test VarChar(20)

SET @Test = SUBSTRING('140PTOHCO 2DTT707904 CCONTINENTAL AIRLINES 460120030822 N', 12, 17)

print @test

Thanks

J. Kusch

 

[mariayx]

Thanks!
That's exactly what has happened.