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

Articles with tag ISNUMERIC() Rss

Search for any content tagged isnumeric()

   Items 1 to 3 of 3   
 

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,248 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,782 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,782 reads
   Items 1 to 3 of 3