hallo
Does anybody has any idea how to search for text in MEMO/BLOB fields case insensitively? I am using UPPER(fieldname) LIKE UPPER("%searchtext%") for usual columns, but the UPPER function doesnt work on BLOB/MEMO fields.

I am using DBF tables and TQuery component on borland delphi BDE .

thanks