Replacing characters in Fields

[luvtitans50]

I have a SSN field: 000000000

I want it to print out as :

***-**-0000

How can I accomplish this?

Thanks for any suggestions!

 

[gmmastros]

You can use the stuff function the add the dashes, like this...

Declare @SSN VarChar(20)

Set @SSN = '123456789'

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

Do you mean that you literally want to see the *'s instead of the actual number?

If so, it's even easier.

Declare @SSN VarChar(20)

Set @SSN = '123456789'

Select '***-**-' + Right(@SSN, 4)

-George

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

 

[luvtitans50]

Awesome!! Thanks a million!!