Re: Case INsensitive search (fwd)

> > A more generic way of doing this follows: > > SELECT * from customer > WHERE name MATCHES "[A-Z][A-Z]*"> > >SELECT * > >FROM customer > >WHERE name MATCHES "[Jj][Oo]..."> The only problem with these strategies is that it means doing some parse work on the CONSTRUCTed query phrase. I'm going to try my idea out and let y'all know... cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ Lysdexics Untie! _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________