Re: How to specify "UPPERCASE" for data?

Use row level insert/update trigger.

Xuequn XU (Robert)

Keith Kwiatek (kkwiatek_at_nist.gov) wrote:
: Hello,

: Is there a way to automatically "upper-case" all data that is
: inserted/update into a particular column? -->I know you can do this with
: UPPER(), but is there a lower level way of doing this, like in the "create
: table", so that even if your sql doesn't have an Upper() function, the data
: will still be put into the table as an upper case?

: Thanks
: Please post or email me at kkwiatek_at_nist.gov
: Keith
Received on Sat May 01 1999 - 20:23:17 CDT