Can you use ASP ADO "Like" to perform a "Not Like" search?

[Adam Short]

I've never needed it before but now I do!

Does anyone know if you are able to perform a NOT Like search using Classic
ASP ADO?

i.e. myData.Filter = "Ref NOT LIKE '*1234*'"

by the way this doesn't work!! and neither does myData.Filter = "Ref <> LIKE
'*1234*'"

or myData.Filter = "NOT Ref LIKE '*1234*'"

Regards

Adam

--
Phuture-UK [phone]

[Ray Costanzo [MVP]]

What kind of database?

Also, don't use the filter method of the recordset. By doing that, you're
bringing back all kinds of data that you have no use for, only to filter it
out after the fact. Instead, handle the filtering in the query itself.

SELECT this, that, theOther FROM yourTable WHERE Ref NOT LIKE '%1234%'
Ray at work

"Adam Short" <ad**@phuture-uk.net> wrote in message
news:Ot**************@TK2MSFTNGP10.phx.gbl...

I've never needed it before but now I do!

Does anyone know if you are able to perform a NOT Like search using Classic ASP ADO?

i.e. myData.Filter = "Ref NOT LIKE '*1234*'"

by the way this doesn't work!! and neither does myData.Filter = "Ref <> LIKE '*1234*'"

or myData.Filter = "NOT Ref LIKE '*1234*'"

Regards

Adam

--
Phuture-UK [phone]

[Bob Barrows [MVP]]

Adam Short wrote:

I've never needed it before but now I do!

Does anyone know if you are able to perform a NOT Like search using
Classic ASP ADO?

i.e. myData.Filter = "Ref NOT LIKE '*1234*'"

by the way this doesn't work!! and neither does myData.Filter = "Ref
<> LIKE '*1234*'"

or myData.Filter = "NOT Ref LIKE '*1234*'"

Regards

Adam

No, the NOT keyword is not allowed in the Filter property. While I echo
Ray's advice to use a WHERE clause in your sql string, I do recognized that
you may need to do multiple filters against the same set of records,
hopefully using a disconnected recordset. In this circumstance, here is a
workaround:

What you can do is use the Clone method to create a new copy of the
recordset, apply the filter to the clone using LIKE, delete the records
resulting from the filter from the clone and remove the filter.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.