On Apr 2, 8:24=A0am, Carlos <miotromailcar...@[EMAIL PROTECTED]
> wrote:
> On 2 abr, 11:19, Andreas Mosmann <mosm...@[EMAIL PROTECTED]
>
>
>
>
>
> 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 =A0 ' -> trim(upper(..))=3D'ABC'
> > 'ABC' =A0 =A0-> trim(upper(..))=3D'ABC'
> > 'aBC ' =A0 -> trim(upper(..))=3D'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
|
