Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi

Another solution with Tools SQL to add data with leading zeroes in a 5 digit ZIP text field:

UPDATE "zipTbl"
SET "ZIP" = RIGHT('00000' || "zipint", 5)
  • Concatenating 5 zeros before the number
  • Keep the last 5

Regards