ISINTEGER function

This function is similar to the ISNUMERIC native function, but tests for a valid integer.  ISNUMERIC can return false positive results when testing for a valid integer.  For example this select returns a value of 1 (true):select isnumeric('3d8')For 6.x and 7.0, you can easily convert it to a procedure.

5 (3)

2003-08-14

1,525 reads

Blogs

Quick Blog: Making the Power BI PowerShell cmdlets easier to use

By

One of the top reasons I love PowerShell so much is that from the...

Trouble writing? Join the club. #JustWriteTech

By

I was talking with  a couple of excellent SQL people* recently, and we were bemoaning...

Check Query Progress with Live Query Stats

By

This is something I touched on back in 2017 a little after the Live...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Need some advice as to how convert reports to use embedded data

By Rod at work

I've been using SSRS, on and off, for about 10 years. I wouldn't call...

Index maintenance Ola script

By vsamantha35

Hi All, Does Ola Hallengren index script takes care of de-fragmenting HEAP tables as...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers