How to get if a string is a number in T-SQL

Asked 2010-01-21T13:42:19.653

Is there an easy way to get if string is an integer number (consists only of digits) in MS SQL 2005?

Thank you for your help.

sql-server-2005 t-sql

Edit Report

1 Answer

-1

Standard T-SQL function ISNUMERIC ( expression ) Determines whether an expression is a valid numeric type.

answered 2010-01-21T13:48:22.577