> 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.
Ran into this on MySQL: SELECT * from table where UPPER(column) LIKE "...." (but on mysql it was UCASE :-) HTH! L8r, Rob
