Home Forums Article Discussions Article Discussions by Author Discuss content posted by William Talada IsNumber fails cast while IsBigInt passes cast RE: IsNumber fails cast while IsBigInt passes cast
boris-1116387
SSCrazy
Points: 2097
More actions
June 2, 2010 at 10:17 am
#1175412
There is simpliest way to found non numeric symbols in string:
.....
if patindex('%[^0-9]%',@s)>0
set @value=0
....