Ron Johnson wrote:
> Since there are only 50 states, plus territories and Canada,
> changing [bill|alt]_state to CHAR(2) is a good idea.
... only a good idea if you know the customer base is North America
only. Outside the USA, CHAR(2) is a dubious choice. Probably doesn't
matter in this instance. :-)
Giles