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 5 of 5   
 

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,599 reads

ISNUMERIC(varchar)

By Kanu Gami 2013/10/15 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,731 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 | 32,953 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 | 32,953 reads

Conversion Fun

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