Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-09 : 15:19:56
|
Josh Saiz writes "I am currently stuck on how to handle international and US addresses in my database.
I have the following fields used to store addresses:
Address1 (varchar(50))
Address2 (varchar(50))
City (varchar(50))
State (char(2))
Zip (varchar(10))
The above works for US/domestic addresses, but it fails when international addresses come into play. I could easily add a country field, but it doesn't solve the problem with a empty State and possibly Zip field.
The information may be printed in a form letter and/or labels.
What is the best way to store international addresses in a relational DB? I really don't want to sacrifice extending table/record size for only a handful of international addresses." |
|
|
|
|
|
International Addresses Dilemma...