General discussion

  • Creator
  • #2175365

    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?

All Comments

  • Author
    • #3330731

      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

    • #3325818

      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.

Viewing 1 reply thread