Re: Force input data to upercase?

In a previous article, bdreher_at_aol.com (BDreher) says:

>I'm looking for a method to force a users inserts to a table to
>switch lowercase text to uppercase.
>

Use the UPPER() function. If you've got the user input in a memory variable or another table column, you can simply specify the translation as one of the VALUEs in the INSERT statement (INSERT into ... VALUES (pk, var1, UPPER(var2), ...) ).

Karla Johnson

-- 
+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=
Karla Johnson                       |      Internet: karjohn_at_kincyb.com
S/W Engr., Informax Data Systems    |                  or ab803_at_lafn.org
Los Angeles, California             |   Standard disclaimers, ad nauseam