script to remove a character from the data in a field

[jayjabour]

We have a table called Patient with a field Sin (which is their Social Security Number). Some people put the SSN in with the dashes and some with out. I need to go through the table and remove the dashes, so all the SSN will not have dashes. Can anyone help me out with this?

[jayjabour]

I got it, this worked:
update patient set "Sin"= REPLACE ("Sin",'-','') where "Sin" like '%-%'