Re: Automatic UPPER conversion on an Insert

From: Sam <sam_samy_at_excite.com>
Date: Thu, 21 Oct 1999 16:38:01 -0400
Message-ID: <7untl9$rb$1@ffx2nh3.news.uu.net>

Yup, that was the obvious One. Is there any way to Enforce this conversion at the Column defn ( User defined fns ? )

Thx

-Thiru
Peter Okhiria <peter.okhiria_at_mci.com> wrote in message news:380F2465.3F240811_at_mci.com...
> why not use the upper() function to do the conversion at the point of
> insertion/update...
>
> Sam wrote:
>
> > Hi all
> > Is there any way to automatically convert the Inserted Value into UPPER
case
> > ?
> > I want to avoid Triggers and am looking for something like Column defn
or
> > Constraint ..
> >
> > Thx
> >
> > Sam
>
>
>
Received on Thu Oct 21 1999 - 15:38:01 CDT