"LurfysMa" wrote

> Since there are only 50 states, the
> savings would be negligible even
> if we annex Canada one day! ;-)

Your mileage may vary, but I've never done a database using states where I
did not, sooner or later, need the state abbreviation, as well as other
information. And, just for the record, my much-used and
much-copied-from-database-to-database "state" lookup table is actually a
table of "US states and Canadian provinces" and, any day now, I may have a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13100-primary-keys.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13100
client who will need Mexican states and their abbreviations, too.

In any case, since I need them anyway, I index on the state/province
abbreviation which may give a very minute performance advantage -- it
certainly will not be very significant.

Larry Linson
Microsoft Access MVP