how do i get - out of ssn

[sbcsandhu]

how do i get the dashes out of the ssn

123-45-6789

would like to see it as
123456789

 

[AlexCuse]

Remember the Replace() function we used for your last question?

[small]----signature below----[/small]
I'm pushing an elephant up the stairs

My Crummy Web Page

 

[PatriciaObreja]

SELECT REPLACE('123-45-6789', '-', '')