Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

General discussion


Reformat Column in Access

By steve.mallard ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

This should work

by Tony Hopkinson 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

Collapse -

many thanks!!!!!!!!

by steve.mallard In reply to This should work

many thanks!!!!!!!!

Collapse -

Wrong forum

by deepsand 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.

Related Discussions

Related Forums