Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle vs Sybase
>
You can use a trigger on update for every varchar field (select upper(:new.field_name) into :new.field_name from dual;) or if you want to preserve your case sensitive data and ONLY search case insensitive you can use where upper(field_name) like upper'your_serach_string%' To increase performance aou can use the new feature of 8i, function based indexes (create index ...upper(field_name)) Received on Tue Mar 28 2000 - 00:00:00 CST