On 2 abr, 11:19, Andreas Mosmann <mosm...@[EMAIL PROTECTED]
> 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.
|
