made a major boo boo importing zip code

Last Post 10 Apr 2009 05:50 AM by triley01. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
triley01
New Member
New Member

--
09 Apr 2009 09:05 AM
Hello, I mistakenly imported many records with only four numbers in the zip code field into my DB. The excel file used had dropped the leading zero.

So what update script could I use to append a leading zero to the records I imported that have only four numbers in that field?


many thanks!
triley01
New Member
New Member

--
10 Apr 2009 05:50 AM
worked perfectly. Your the best!


Acceptable Use Policy
---