12-07-03, 09:19 #1Registered User
- Join Date
- Jan 2003
Unanswered: case insensitive text search in MEMO/BLOB fields
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 .