how to tell if a string is valid integer

[glendacom]

Is there a function that will tell me if a string is a valid integer. It would work something like this:

somefunc('1234') would return TRUE
somefunc('12a4') would return FALSE

 

[SQLBill]

You probably want the ISNUMERIC function. Check out the Books OnLine, use the index and go to ISNUMERIC for a description and the syntax.

_SQLBill

 

[rajeevnandanmishra]

Glendacom,

Try this:

SELECT CASE ISNUMERIC('1234') WHEN 1 THEN 'TRUE' ELSE 'FALSE' END


Raj