Joseph,

Did you look at the code i posted yesterday? I ran it against the data you provided, and it gives the result you want.

Thanks,

Shahryar

How about:

selectSUBSTRING ( PhoneNo, 3, LEN (PhoneNo) )

Here's some code that seems to work for your problem. It's multi-step, and in incorporates a table variable. this would best be implemented in a stored proc. ...

Maybe it's just me, but I do not see an attached example - is it the picture link at the bottom of the post?