how to do case-insensitive search

[william humphrey]

I am trying to do a case insensitive search. Valentina "like" searches
are case sensitive.

Sometimes I like that but sometimes I want to do a case insensitive
search. How do I do that?

select ID, Name
from myTable
where case-insensitive(say) like binary '%J%'
*target result*

(1) Jane
(2) jane
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina/attachments/20091210/6b4bdd03/attachment.html