I'm guessing this is a really common question, but my book is unable to
I want to do a search like:
select * from dbname where name like "%joe%"
But what that gives me is "joe" and "joeseph". What I want is a case
insensitive version, so that I can get "Joe", or "joe", or "Joeseph",
or "McJoESePh" or anything.
How do I do that?
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.