How to get integer and string records from the existing table in sql server?

Purushottam Rathore

Aug 07, 2012

1.9k

select * from // it fetch all record of table and also diff datatype aswell

February 03, 2016

Write the following query to get only integer records.

SELECT * FROM TableName WHERE ISNUMERIC(ColumnName) = 1

Write the following query to get non integer records.

SELECT * FROM TableName WHERE ISNUMERIC(ColumnName) <> 1

August 07, 2012