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
at

2 comments:

  1. Anonymous10:02 AM

    Now, the question is, why?

    ReplyDelete
  2. Anonymous10:27 AM

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

    ReplyDelete