On Wed, 2 Jan 2019, Ron wrote:
Note that a CHECK constraint with 50 items is a *Very Bad Idea*, since changing such a constraint is very painful. Use a FK constraint instead.
Ron, It's even longer with Canadian provinces included. I gratefully accept your advice and will use a table and foreign key instead. Regards, Rich