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

Blogs

Clustering SAP #ASCS and #ERS on #AWS using Windows Server Failover Clustering

By

When ensuring high availability for SAP ASCS and ERS running on WIndows Server, the...

Ethics in Modern Data at the Baton Rouge Analytics and Intelligence Network (BRAIN)

By

On July 27, Christine and I will present our joint presentation on Ethics in...

Heading Font Weights and List View Toggles Arrive in Block Editor and WordPress 5.8

By

With the WordPress 5.8 release, we're starting to introduce features that overall improve your...

Read the latest Blogs

Forums

convert hours into decimal

By jeannier1975

i have a formula that calculates the difference between two dates and tells me...

Get charges percentage per entity\channel

By Bruin

I trying to figure out what percentage of the total charge for a ME...

How to find islands and get max and min range values

By itlk

I am trying to create groups for each Name and save the max and...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers