My database has phone numbers, some that are already formatted correctly and some that are null.
I need a command that I can run on the server to updated these numbers so they are all in this format xxx-xxx-xxxx.
Not sure how to weed out the ones already in that format and the nulls. And also verify there are 10 digits before applying format.
I'm using sql server 2005