Re: Case Insesitive search (how)

Richard Krenek <rkrenek@ihs.com> wrote: >Hello all, > How do I do a case insesitive search. Lets say I have a field "This >Is A Test", I would like to seach for it using "this is a", (SELECT * >FROM table WHERE field LIKE '%this is a%' ) does not work. Any ideas? > >Richard Krenek > SELECT * FROM table WHERE lower(field) matches 'this is a' or WHERE upper(field) matches 'THIS IS A' carlos Currently on hiatus from unemployment. ---------------------- Do you do Linux? :) Get your FREE @linuxstart.com email address at: http://www.linuxstart.com