Software·43,767 discussions

Reformat Column in Access

Locked

Need to reformat column with data in it and truncate the first characters of data. Have an access database (XP)with SSN column. Formated as such 111-11-2222. How can I write query, sqlview query to drop the 111-11- and keep the last four….for over 46,000 records?

Topic

This should work

In reply to Reformat Column in Access

update mytable set ssn = right$(ssn,4)
should work.
Needless to say but back up your file before you discover either of us has made a typeo
PS. As Deepsand often says “Wrong Forum” should be putting this in Technical Q&A

many thanks!!!!!!!!

In reply to This should work

many thanks!!!!!!!!

Wrong forum

In reply to Reformat Column in Access

This is a tech. problem, in search of a solution.

It properly belongs in “Technical Q&A,” not in “Discussions.”

Please re-post there.

Thank you.

[Author]

Replies