I'm glad everyone seems to like this question. 🙂
SQL Server's handling of trailing spaces has bitten me a couple of times. I find it somewhat counter-intuitive.
Nice question. A good refresher on string comparisons.
Good question... thanks!
I have given a name to my pain...MCM SQL Server, MVP
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
A very good question - it took a bit of head scratching... Thanks!
im agree the answer but when you select or print @a
this have 19 spaces and the answers are wrong when you say this is correct
think computers say 1 is 1 no 1 without spaces
L' Eomot Inversé (5/9/2012)It would have been somewhat shocking if I had got this one wrong after writing the 15th April 2010 QotD 😛
I thought the subject seemed familiar!
Good question....it's really true that everyday you learn something new.
Thanks for the great question on LEN() function.
Good question. Thanks for submitting.
Helped me with LIKE vs =
Viewing 13 posts - 16 through 27 (of 27 total)