Convert existing numerical data to include a ' - '

I have a field in which some Social Security Numbers were entered with out the dashes. 123456789. We need to change the numbers that do not have dashes to a format with dashes, ie.. 123-45-6789.

Does anyone have a sql script to reformat the numerical data?
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!