I am working in SQL Server 2008. I am trying to test whether a string (varchar) has only digit characters (0-9). I know that the IS_NUMERIC function can give spurious results. (My data can possibly have $ signs, which should not pass the test.) So, I'm avoiding that function.
I already have a test to see if a string has any non-digit characters, i.e.,
some_column LIKE '%[^0123456789]%'
where some_column NOT LIKE '%[^0-9]%'
declare @str varchar(50)='50'--'asdarew345' select 1 where @str NOT LIKE '%[^0-9]%'