Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag ISNUMERIC() Rss

   Items 1 to 6 of 6   
 

IsNumeric

By Gaurav Jha 2015/01/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,515 reads

It's Dangerous to ISNUMERIC, Take This Try_Convert

There's an issue with some characters in T-SQL when validating numeric values out of raw varchar fields, and it can...  Read more...
By William Assaf 2013/12/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,912 reads

ISNUMERIC(varchar)

By Kanu Gami 2013/10/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,781 reads

Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Another in our series of articles to help you fill in the cracks in your knowledge with SQL Spackle. MVP Jeff Moden shows us how IsNumeric works and how you should use it.  Read more...
By Jeff Moden 2012/09/14 (first published: 2010/12/01) | Source: SQLServerCentral.com | Category: isnumeric()
Rating: |  Discuss |   Briefcase | 33,376 reads

Why doesn’t ISNUMERIC work correctly? (SQL Spackle)

Another in our series of articles to help you fill in the cracks in your knowledge with SQL Spackle. MVP Jeff Moden shows us how IsNumeric works and how you should use it.  Read more...
By Jeff Moden 2012/09/14 (first published: 2010/12/01) | Source: SQLServerCentral.com | Category: isnumeric()
Rating: |  Discuss |   Briefcase | 33,376 reads

Conversion Fun

By Mark Horninger 2009/08/07 | Category: conversions
Rating: (not yet rated) |  Discuss |   Briefcase | 3,971 reads
   Items 1 to 6 of 6   
 
Tags
t-sql (4)    
blogs (1)    
conversions (1)    
sql spackle (1)    
try_convert() (1)