Please help me out on this

Hi! we are using Oracle 8 standard edition, The problem is when user does query from web site for text field he or she may type in Ucase or Lcase letter, but since Oracle is case sensitive(I believe), if I applied upper or lower function on both side of where clause it will suppress the index on the column causing performance problem and function based index is not supported on Oracle 8standard editiond. so is there any way I can turn off case sensitivity of oracle and if not how can I get around this problem? any hint will be appreciated. thanks.

kush Received on Wed Oct 11 2000 - 14:33:52 CDT