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

Purushottam Rathore

12y

1.9k

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

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

12y