Re: 9i: Check- constraint Upper(Column)

On Apr 2, 8:24 am, Carlos <miotromailcar..._at_netscape.net> wrote:
> On 2 abr, 11:19, Andreas Mosmann <mosm..._at_expires-30-04-2008.news-
>
>
>
>
>
> group.org> wrote:
> > Hi newsgroup,
>
> > Is it possible to build a constraint, that ensures, that there are not
> > more entries in a column, that look like
> > 'Abc   ' -> trim(upper(..))='ABC'
> > 'ABC'    -> trim(upper(..))='ABC'
> > 'aBC '   -> trim(upper(..))='ABC'
> > ?
>
> > Alternativ I could build a shadow column filled by a trigger that
> > containes trim(upper(..)) and a check constraint on this, but it seems
> > to me that there is a better way.
>
> > Thank you in advance
> > Andreas Mosmann
>
> > --
> > wenn email, dann AndreasMosmann <bei> web <punkt> de
>
> Not sure about what you're trying to do, but a Function Based Unique
> Index on (trim(upper(column))) may do the trick...
>
> HTH.
>
> Cheers.
>
> Carlos.- Hide quoted text -
>
> - Show quoted text -

A check constraint can be written using the upper() function. I've done that before and it works without issue.

David Fitzjarrell Received on Wed Apr 02 2008 - 09:22:06 CDT