title: Correcting truncated zip codes in Magento through SQL query
body: <p>Zip codes with leading zeroes were truncated without the zeroes after a migration from X-Cart to Magento. I'm trying to run a SQL query to add the zeroes back but don't know which table/column to run it against in the database. We use the zip code to determine which shipping services will be available to the customer during checkout. Does anyone know where the shipping address (both default and additional) zip codes are located in the database?</p>