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
What does this return?
SELECT ISNUMERIC('+'),ISNUMERIC('–')
Copy and paste it into QA/SSMS to verify :-0
Labels:
Teaser
Subscribe to:
Post Comments (Atom)
2 comments:
Now, the question is, why?
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!!
Post a Comment