Find a record using ADODC - "LIKE *"

[Koshees]

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.

[dinesh123]

Will this do ur work.

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

[Zeb]

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.