kapil190588 (10/3/2012)
how Casting or converting a string literal behaves returning 30 characters.this is the only thing on which am stuck..
plz explain
I think it has to do with "SET ANSI_PADDING ON" and the default length of varchar being 30.
Just answer off the top of my head from memory. If anyone knows better feel free to correct.