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

TRY_CONVERT and IsNumeric

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


By Gaurav Jha 2015/01/05 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,573 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,900 reads


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   
try_convert() (2)    
blogs (1)    
conversions (1)