Software

Ask something
Discussion Locked

Reformat Column in Access

0 helpful
3 replies

by steve.mallard

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

3 replies

by tony hopkinson

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

by deepsand

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.

This discussion is closed to new replies.