Find a record using ADODC - "LIKE *"

How to find a record using ADODC.find method to find a record "LIKE variable*"

I want to use a variable + * , ie if content is "B" then it should take "LIKE 'B*'". Here instead of 'B' I want to use the variable name itself.

Will this do ur work.

Code:

---

Adodc2.CommandType = adCmdText
Adodc2.RecordSource = "SELECT * from qryInterests1 WHERE [Gender] like '%" & Gender & "%'"
Adodc2.RecordSource = "SELECT * from qryInterests1 WHERE [Age] = '" & age & "'"
Adodc2.Refresh
If Adodc2.Recordset.EOF Then
MsgBox "No records found", vbOKOnly
End If

---

Careful which DB you are using too - some use "*" as the wildcard, others use "%", so if it doesn't work with one, try it with the other.