"Like" operator in a query

In "SQL Server Compatible Syntax" setting in Options dialog; Table/Queries
tab, I do not check "This database".

In this database the following query returns two records:
SELECT Filters.Filter FROM Filters WHERE (((Filters.Filter) Like
"*Classes*"));

If I write code as follows, it returns no records:

Dim adoRS As New ADODB.Recordset
sSQL = "SELECT Filters.Filter FROM Filters WHERE (((Filters.Filter) Like
""*Classes*""));"

adoRS.Open sSQL, oConn
If adoRS.EOF Then
Debug.Print "No Records"
End If

Is there a way to get ADODB code to properly handle the "Like" operator?

Use "%" rather than "*" in ADO.

--
Duane Hookom
MS Access MVP
--

"genojoe" wrote in message
news
In "SQL Server Compatible Syntax" setting in Options dialog; Table/Queries
tab, I do not check "This database".

In this database the following query returns two records:
SELECT Filters.Filter FROM Filters WHERE (((Filters.Filter) Like
"*Classes*"));

If I write code as follows, it returns no records:

Dim adoRS As New ADODB.Recordset
sSQL = "SELECT Filters.Filter FROM Filters WHERE (((Filters.Filter) Like
""*Classes*""));"

adoRS.Open sSQL, oConn
If adoRS.EOF Then
Debug.Print "No Records"
End If

Is there a way to get ADODB code to properly handle the "Like" operator?