Filtering Paradox Tables on Memo Fields
Posted on 1998-12-19
With 16 Delphi 1, you could create an SQL query:
Select * from TableName
where MemoField LIKE '%SearchString%'
and get all fields matching the SerachString - regardless of
the case of the SearchString.
In 32 bit Delphi, it doesn't wotk any more. The match is always case sensitive. This also behaves like this in DBD and SQL explorer and ReportSmith, so the problem must be in BDE. (Interestingly, it works OK in Crystal Reports).
Can anyone help a desperate man? I cannot find the answer anywhere.