## ISNUMERIC(varchar)

 Author Message kanu.gami SSC-Enthusiastic Group: General Forum Members Points: 175 Visits: 61 Comments posted to this topic are about the item ISNUMERIC(varchar) Dhruvesh Shah SSC Eights! Group: General Forum Members Points: 979 Visits: 237 Good question. Any one know why it returns 1 for some/most of special characters? Ken Wymore SSCertifiable Group: General Forum Members Points: 7861 Visits: 2416 Two days in a row of easy questions. Didn't have to think long on this one! :-)As for why many special characters show up as numeric, it has to do with how those characters are commonly used to represent numerical data. For a great explanation, see Jeff Moden's article on this: http://www.sqlservercentral.com/articles/IsNumeric/71512/ ksatpute123 SSCommitted Group: General Forum Members Points: 1988 Visits: 383 I had to google my way for the answer. Nice question, learned something new. Don't know if I will be ever using it. T.Ashish SSCommitted Group: General Forum Members Points: 1837 Visits: 618 Why it returns 1 ? Stuart Davies SSCrazy Eights Group: General Forum Members Points: 8989 Visits: 4840 T.Ashish (10/15/2013)Why it returns 1 ?ISNUMERIC returns 1 if the value could be interpreted as a number and 0 if it couldn't. The three examples in the QOTD gave 1 as they are a minus sign, dollar sign and a decimal point, so therefore could be part of a number (-0,\$0,0.0). "This" could not be regarded as being a number, so would return 0. -------------------------------Posting Data Etiquette - Jeff Moden Smart way to ask a questionThere are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan I would never join a club that would allow me as a member - Groucho Marx Bangla SSCrazy Group: General Forum Members Points: 2033 Visits: 180 Nice question..First thought 000..Then I read the question again .....Got it at last but took help.... Stewart "Arturius" Campbell SSC-Insane Group: General Forum Members Points: 24695 Visits: 7501 Interesting question, thanks ____________________________________________Space, the final frontier? not any more...All limits henceforth are self-imposed.“libera tute vulgaris ex” Anipaul SSChampion Group: General Forum Members Points: 11839 Visits: 1407 Nice and interesting question..... sqlnaive SSCrazy Eights Group: General Forum Members Points: 8253 Visits: 2774 Stuart Davies (10/15/2013)T.Ashish (10/15/2013)Why it returns 1 ?ISNUMERIC returns 1 if the value could be interpreted as a number and 0 if it couldn't. The three examples in the QOTD gave 1 as they are a minus sign, dollar sign and a decimal point, so therefore could be part of a number (-0,\$0,0.0). "This" could not be regarded as being a number, so would return 0.+1. I got it straightaway. There was one question posted regarding ISNUMERIC few days back and therefore had read on this topic. :-)