Friday, April 25, 2008

SQL Teaser: Some Things Are Not What They Seem

This one is a little sneaky, don’t send me hate mail for it.

What does this return?


Copy and paste it into QA/SSMS to verify :-0


Anonymous said...

Now, the question is, why?

Sean said...

The "trick" is the character '-'. The author used a character other than the char(45) minus symbol. The dead giveaway is the "Copy and paste it" comment. Anyone who works with data on a daily basis should know better!!