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

    .....

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

    set @value=0

    ....