Hey all, this is wonderful information.

Many many thanks.

David

Of course, I should have posted it. I ended up at

http://databases.about.com/od/access/a/zipcodedatabase.htm

It was an Access database that I moved to SQL Server 2008.

It's a little old and some...

Never mind, scratch that. I did some searches on the Internet and found some sources.

By the way, thanks for the code below.

David

Hi guys, I know this is an old thread and am hoping you still are connected with SQL Server Central.

By any chance, do you know where I can get a...

No, I didn't think of that, but good suggestion. I'll take a look at Codewright.

What I might also do is have two instances of Query Analyzer open, one in...

Thanks for the reply. I've always used Query Analyzer because that came with SQL Server and I never bothered to look at anything else. Are there other tools...

Thanks Todd, that's pretty much what I was looking for but didn't really know how to best formulate the select.

David

Thanks guys. I decided to not be lazy and list out each field in the insert statement. I just put a note in the stored proc that if...