Howdy, Stranger!

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

Categories

Convert existing numerical data to include a ' - '

madonnavmadonnav Member Posts: 1
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.