Reformat Column in AccessLocked
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?
Viewing 1 reply thread