ISNUMERIC(varchar)

• prakashr.r7

  SSCrazy

  Points: 2828

  More actions

  October 21, 2013 at 4:25 am

  #1660070

  Last week, I had this situation where my result showed 1 instead of 0 when the values had minus sign. I was confused and did not want it in that way. But now, after reading this question and Jeff's article, i came to know why it is.

  Any way , Thanks a lot for this question. Actually this is a timely question for me.

• Umer Akram

  SSC-Insane

  Points: 22209

  More actions

  October 21, 2013 at 4:31 am

  #1660072

  ISNumeric() function have this tendency to trick you in, especially if you want to type cast the data

• jfgoude

  SSCrazy

  Points: 2586

  More actions

  October 31, 2013 at 3:45 am

  #1662962

  Nice and easy basic question