Zip Format

[DizzyD]

I've created a search script to find a business by city, state, or zip. The only problem I've come across is the zip. I have to enter the zip codes for the select county by hand 1 by one, and there are hundreds per business! Luckily I've found a site where i can just copy and paste all at once. So here in lies my question. In my "insert" script i just fill in the details and when it comes to the zip field is there a more efficient way of entering the zip codes? Because when i just hit paste i get all the zips one per line. Is it more efficient if i have them all just separated by commas or spaces or what?

[NogDog]

Probably the "normalized" way would be to have a separate table for zip codes. Each row of that table would be one zip code with a 2nd column being a foreign key to the primary key field of the business table.