>Why not use LIKE?
>
>declare @ssn nvarchar(40)
>set @ssn = '123-45-6789'
>IF @ssn LIKE '[0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9][0-9][0-9]'
> print 'yes'
>else
> print 'no'
>
>-Mike
>
Maybe because it isn't on the top of my head? :)
Than again, how much T-SQL could somebody learn from that code? :)