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?



SELECT ISNUMERIC('+'),ISNUMERIC('–')

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

2 comments:

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!!