Sample Header Ad - 728x90

SQL in Access to add leading 0 in front of zip codes

1 vote
1 answer
1355 views
for a project I am working with a table of zip-codes that I imported from a *.csv file, exported form Excel. Those zipcodes all have 5 numbers and are formatted as text within my database. Some of them should start with 0, however during the export/import process this 0 got lost, leaving me with zip-codes that only have 4 instead of 5 digits where the leading 0 went missing. Is there a way an SQL command might add this zero to strings only having 4 digits? Thank you
Asked by Titan (11 rep)
Mar 21, 2022, 01:05 PM
Last activity: Jun 29, 2025, 08:05 AM