October 14, 2013 at 8:03 pm
Comments posted to this topic are about the item ISNUMERIC(varchar)
October 14, 2013 at 8:58 pm
Good question. Any one know why it returns 1 for some/most of special characters?
October 14, 2013 at 11:01 pm
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/"> http://www.sqlservercentral.com/articles/IsNumeric/71512/
October 14, 2013 at 11:29 pm
I had to google my way for the answer. Nice question, learned something new. Don't know if I will be ever using it.
October 15, 2013 at 12:13 am
Why it returns 1 ?
October 15, 2013 at 12:56 am
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 [/url]Smart way to ask a question
There 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
October 15, 2013 at 1:31 am
Nice question..First thought 000..Then I read the question again .....Got it at last but took help....
October 15, 2013 at 1:32 am
This was removed by the editor as SPAM
October 15, 2013 at 1:34 am
Nice and interesting question.....
October 15, 2013 at 1:50 am
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. 🙂
October 15, 2013 at 2:11 am
Easy one! Thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 15, 2013 at 2:43 am
For me this is one of the big issues with 2008. As these will pass isnumeric but some of them (for instance ",") will then not convert into decimals floats etc. It would however i believe convert into money.
In 2012 there is now Try_Convert which i am hoping will be much better for sorting this out.
October 15, 2013 at 5:30 am
ksatpute123 (10/14/2013)
I had to google my way for the answer. Nice question, learned something new. Don't know if I will be ever using it.
Nice question ....
October 15, 2013 at 5:59 am
Interesting.... Thanks!
---------------
Mel. 😎
October 15, 2013 at 6:43 am
+1 to the good question, it forced me to research if the symbols could be labeled as "numbers".
I am still trying to find it but I remember someone in forums suggested rewriting the function to remove such use cases.
Viewing 15 posts - 1 through 15 (of 33 total)
You must be logged in to reply to this topic. Login to reply