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 10:15 pm
#1588189
raguyazhin (2/14/2013)PATINDEX('%[^0-9]%', LHP_PARAM_RESULT_VALUE) = 0
raguyazhin (2/14/2013)
The key, then, is the Not-to-match operator, "^". Zero returned means PATINDEX() found no characters other than digits, 0-9. Got it! Thanks for the clarification.