Oracle Translate Function in SQL Server 1

[psamedy]

Hello all,

I'm looking for a sql server function that works similar to the TRANSLATE function in ORACLE. I have social secturity field currently in format ###-##-####, that i'd like to change to ######### (without the dashes). The TRANSLATE function would work as follows:

TRANSLATE('123-45-6789','-','') would return 123456789

Thanks Pat

 

[NathanGriffiths]

The function you are looking for is REPLACE

e.g REPLACE('123-45-6789','-','') would return 123456789



Nathan