There is simpliest way to found non numeric symbols in string:

.....

if patindex('%[^0-9]%',@s)>0

set @value=0

....