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