Re: Force Upper Case

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Sat, 06 Oct 2007 10:46:30 -0400
Message-ID: <at7fg35dud05l7fg7acuai8fp7bq93lv6o@4ax.com>

On Fri, 05 Oct 2007 08:46:05 -0700, "learning_codes_at_hotmail.com" <learning_codes_at_hotmail.com> wrote:

>Hi,
>
>I have about more than 175 fields. Some are different (Characters,
>Date, Numeric, etc). I'm trying to force all capital letter only on
>Character Types at once. I hate to type each of the fields.
>
>Ucase([LastName])
>
>How to set for all fields (characters only) ?
>
>Your help would be much appreciated.

Do an update like others suggested.
Create a before insert trigger if you can't control on the app end. .......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Sat Oct 06 2007 - 09:46:30 CDT