Wednesday, June 01, 2016

How to select data in a column with only INT?

Recently I ran into an issue where i need to filter column to get only integer values.

select * from employee where ISNUMERIC(employeeid ) = 1

ISNUMERIC function returns 1 if the expression is a valid number. Otherwise, it returns 0

The ISNUMERIC function can be used in the following versions of SQL Server (Transact-SQL):

  • SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005

No comments:

Post a Comment