Perl 5.6.0 DBI 1.20 DBD:Oracle 1.12 Sun Solaris 2.7 Oracle 8.1.7.0 Is there a way to get LIKE to be case-insensitive? I want this for two reasons:
I have a user database which I present in a Rolodex fashion. If someone clicks on the "D" tab, I want to display "diLoreto" along with "Davidson". The statement select * from user_list where LastName like 'D%'; only returns those lastnames starting with "D". Second reason for this, check for conflicting names already in the user database. If someone is already in the database as FirstName="John", LastName="Doe", I want to be able to say something like: select * from user_list where LastName like 'Doe' and FirstName like 'John'; to spot conflicts if someone enters LastName="DOE" and FIRSTNAME="JOHN". With my old DB, there was an operator "CLIKE" that would do this. Oracle seems to have no such operator. --Chuck
