Re: Case insensitivity in frontend queries (2nd Posting)

> In this case I'm using new column deriwated from value of column
 which
> have to be case insensitive. In trigger on update or insert of
> this column I fill value to new column as
>
> :new.insensitivecolumn := UPPER ( :new.casesensitivecolumn );
>
> Then where clause in SELECT statement is like this
>
> SELECT casesensitivecolumn
> FROM ..
> WHERE insensitivecolumn = UPPER ( value );
>
> This solution has no affect on performance, it's only disk space
eater

And how about using index on insensitivecolumn ?

Dmitry, moprok_at_ropnet.ru   Received on Tue Mar 03 1998 - 00:00:00 CST