Adding dashes to an SSN

[renee35]

I have created a report and it includes SSN. The customer would like for that number to include the dashes. Currrently this is how it displays:

123456789 - would like for it to read 123-45-6789?

Thanks!!
Thanks a bunch!!


Thanks a bunch!!

-T

 

[gmmastros]

Select Stuff(Stuff(SSN, 6, 0, '-'), 4, 0, '-')

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[renee35]

Thanks!!

Thanks a bunch!!

-T