On Oct 5, 10:46 am, "learning_co..._at_hotmail.com"
<learning_co..._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.
> Thanks
update <tablename> set colname=upper(colname);
Received on Fri Oct 05 2007 - 12:17:09 CDT
