Hi all,

I'm trying to filter a ADO 2.5 Recordset with
a statement similar to this:

select * from MyTable
where UPPER(StrColumn) like UPPER(CompareStr)

It doesn't seem to be allowed to use Database
functions like "UPPER". So is there any way to
achieve this using the Filter property?
The only way I know so far is to filter the
Recordset by modifying the original select
statement which I'd rather leave untouched.

Thanks in advance

Alexander Kempf