Is there a way, other than triggers, of ensuring that text entered into a column is all uppercase?

Roy Lambert

Roy,

<< Is there a way, other than triggers, of ensuring that text entered into a
column is all uppercase? >>

Nope, that's a job for triggers.  However, you can also just specify a
case-insensitive collation (_CI suffix) for the column so that every single
search is case-insensitive, thus negating the need for an upper-case for the
purposes of searching and sorting.

--
Tim Young
Elevate Software
www.elevatesoft.com