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

Blogs

Regression Testing SQL Saturday Naming

By

I started a poll today on the naming for future SQL Saturdays. You can...

Daily Coping 9 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Error creating Azure SQL Database

By

A quick post today, quite simply, the error message is: “code”: “ConflictingDatabaseOperation”,  “message”: “Operation on server x and database y is in progress.  Please wait a few minutes before trying again.” What...

Read the latest Blogs

Forums

Splitting a group up into multiple groups using a score....

By Rob Reid-246754

Splitting a group up into multiple groups using a score for how many times...

Whether to leave a clustered index on a staging table

By DamianC

Hi Using dataflows to load data from one SQL table to another (seperate databases;...

Questions about Always On

By onlo

Dear all, I have the following questions about SQL Server Always On: How does...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers