Using NOT LIKE in Filter property of VBA recordset

Question

I am using excel 2003 to connect to SYBASE database using VBA recordset. I want to filter the records.

Following is code I have used.

Dim rset As New ADODB.Recordset
rset.Open sQuery, m_db, adOpenForwardOnly
rset.Filter = "Name NOT LIKE 'Dav%'"
rset.Requery

But it is not working and returning all rows. If I use Name LIKE 'Dav%', its correctly returning records with Name starting with Dav.

What is the problem with Not LIKE ? Am I missing something ?

Also, I need to use Requery to get the filter work. Is it really required ?

Thanks in Advance.

Answer 1

Maybe you can include the NOT LIKE in the sQuery value. Like:

select * from NamesTable where [name] NOT LIKE 'Dav%'

Answer 2

The NOT keyword is not allowed in the filter property.