Home Forums SQL Server 2005 T-SQL (SS2K5) Convert Varchar to Decimal RE: Convert Varchar to Decimal
john.arnott
SSChampion
Points: 11882
More actions
February 14, 2013 at 8:43 pm
#1588179
Went looking on the net and found an answer right here in SSC (of course!!). If you want to test for all digits, the expression NOT LIKE '%[^0-9]%' should do it. Do read the entire post from Jeff Moden about testing for numbers.