Just to play devil's advocate, at least two of the official provincial
abbreviations have changed in Canada in recent memory (Quebec used to be PQ,
and now is QC, Newfoundland and Labrador used to be NF, and now is NL). We
also got a 3rd territory a few years back, but an addition to the table
isn't as bad as a change to the PK.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Larry Linson"
wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13100-primary-keys.html
news:O2pg7zdpGHA.1548@TK2MSFTNGP04.phx.gbl...
> "LurfysMa" wrote
>
> > Since there are only 50 states, the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13100
> > 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
> 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
>
>