Case-insentive search

From: Aziz Rahman <arahm_at_ctp.com>
Date: 1996/11/12
Message-ID: <568m7b$3q5_at_concorde.ctp.com>#1/1


We are trying to perform a case-insensitive search on a specific column of a table, e.g.

select cust_name from customer
  where upper(street_address) like upper('pattern%');

Both street_address and pattern are in mixed case. But we also want to be able to use the index on street_address. Is this possible ? Any suggestions or comments will be greatly appreciated.

  • Aziz Rahman
Received on Tue Nov 12 1996 - 00:00:00 CET

Original text of this message