Technical Article

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)

You rated this post out of 5. Change rating

2003-08-14

2,459 reads

Blogs

SQL Server Quickie #46 – SQL Server on Linux

By

Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...

Giving a Security Webinar this Wednesday

By

If you haven’t already signed up, on November 29, 2023, at 11 AM Eastern...

Write to backup block blob device failed. Device has reached its limit of allowed blocks.

By

Picture this, you’re happily backing up your database to a Azure blob storage until...

Read the latest Blogs

Forums

Logging SQLExceptions

By Casper101

We have a web front-end which I believe in some cases is throwing unhandled...

An Incomplete Window Definition

By Steve Jones - SSC Editor

Comments posted to this topic are about the item An Incomplete Window Definition

A Lack of Privacy in Smart Cars

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Lack of Privacy in...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers