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

Purushottam Rathore

13y

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

10y

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

13y