Remove dashes

[Zonie32]

Hi all,

Using MS Access 2003, win xp...

I have a table with a column for Social Security Number roughly 2500 records. Some users put dashes in the SSN number, others have not.

I want to remove all dashes and keep the number uniform like this 123456789, not like 123-45-6789. How do I accomplish this?

Thanks!

 

[Remou]

Replace should suit.

Replace([SSN],"-","")

Aside: I think there are some fairly strict rules about storing SSNs and keeping them secure.

http://lessthandot.com

 

[lameid]

Use an update query and the replace function. Replace dashes with zero lenght strings...

Replace(SSN, "-","",1)

 

[BigRed1212]

If you are stlll accepting user input for the table, once you have it cleaned up you may also want to put in place some client side and/or server side validation that lets in only good data.