SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, ISNUMERIC() Rss

   Items 1 to 6 of 6   
 

Is It Time To Stop Using IsNumeric()?

The old system function IsNumeric() often causes exasperation to a developer who is unfamiliar with the quirks of Transact SQL. It seems to think a comma or a number with a 'D' in the midde of it is a number. Phil Factor explains that though IsNumeric has its bugs, it real vice is that it doesn't tell you which of the numeric datatypes the string parameter can be coerced into, and because it doesn't check for overflow. Phil comes to the rescue with a couple of useful alternatives, one of which works whatever version of SQL Server you have, and which tell you what datatype the string can be converted to.  Read more...
By Additional Articles 2017/08/21 | Source: SimpleTalk | Category: isnumeric()
Rating: (not yet rated)  Rate this |   Briefcase | 4,229 reads

TRY_CONVERT and IsNumeric

By Steve Jones 2017/07/13 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 949 reads

IsNumeric

By Gaurav Jha 2015/01/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,572 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 willassaf@gmail.com 2013/12/17 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,700 reads

ISNUMERIC(varchar)

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

Conversion Fun

By Mark Horninger 2009/08/07 | Category: conversions
Rating: (not yet rated) |  Discuss |   Briefcase | 3,987 reads
   Items 1 to 6 of 6   
 
Tags
try_convert() (2)    
blogs (1)    
conversions (1)