How to perform a case-insensitive query?

Almost ashamed to ask:

Couldn't find anything on how to perform an SQL-Query (via TQuery on a
Paradox table, in a Memo field) that is _not_ case-sensitive!

Does it have to do with the language drivers? or what? Is there any way to
do it at all?

I found the Paradox drivers already are case-insensitive when finding a
single entry in a TTable. But I need to query a large set of Memo

could anyone help?