I was wondering how you handle the missing 0's in US Zipcodes?
Go to Solution.
Convert the Column to Data Type Text in the Query Editor!
Click the icon on the left side of the Column name and select Text
This should fix it!