made a major boo boo importing zip code

Last Post 10 Apr 2009 06:50 AM by triley01. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
triley01
New Member
New Member

--
09 Apr 2009 10: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 06:50 AM
worked perfectly. Your the best!
You are not authorized to post a reply.

Acceptable Use Policy