J.R. Bullington wrote:
The best way to do this is with code, however, here is A way to do it (I am sure that there are more than one...)UPDATE tbl_Name SET ZipCodes = concat('0',ZipCodes) WHERE length(ZipCodes) = 4
How about
UPDATE tbl_Name SET ZipCodes = right(concat('00000',ZipCodes), 5) WHERE
length(ZipCodes) < 5
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
