ADO.Recordset.Filter with like and no case sensitivity

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

'apply filter
rs.Filter = "author like 'J*'" 'author is a field

'eliminate filter
rs.Filter = ""

rs.Filter = "fieldname = " & sCriteria







Iouri Boutchkine
[email protected]

Thanks for your help. It works fine for filters
with no case sensitivity (I was wrong to think
the filter was case sensitive).
Is there also a way for case sensitive filters?

Alexander Kempf