In SQL Server validate if a string contains only numbers

Asked May 13 '13 at 16:55

Active May 13 '13 at 17:01

Viewed 170 times

I have a string '1523987654' and I need to check if only have numbers.

First I had used ISNUMERIC, but it dosen't worked with '.'

SELECT CASE WHEN 
ISNUMERIC('.') = 1
 THEN 1 ELSE 
0
 END

I had try with LIKE, but without sucess

SELECT CASE WHEN 
'1523987654'  LIKE '[0-9]'
 THEN 1 ELSE 0 END

Any suggestions ?

edited May 13 '13 at 16:56

Agustin Meriles

asked May 13 '13 at 16:55

Rui Soares

LIKE '%[0-9]%' (don't you need the %'?) – xQbert May 13 '13 at 16:59
check this post http://stackoverflow.com/questions/4522056/how-to-determine-the-field-value-which-can-not-convert-to-decimal-float-int-i – Agustin Meriles May 13 '13 at 16:59

0 Answers0