Like operator in Where Clause Syntax

[Elysynn]

I'm using the following SQL statement for a search function. I'm having some problems with the like operator. If you could take a look and tell me what I've done wrong, I would appreciate it.

"SELECT tblCoreData.RecordNumber, tblCoreData.AgentName, tblCoreData.AgentID, tblCoreData.Site, tblCoreData.DateEntered" & _
" FROM tblCoreData" & _
" WHERE tblCoreData.AgentName Like '* " & txtSearchData & " & *';"

TIA,
Elysynn

 

[PHV]

Either:
" WHERE tblCoreData.AgentName Like '*" & txtSearchData & "*';"
Or:
" WHERE tblCoreData.AgentName Like '%" & txtSearchData & "%';"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Elysynn]

Thanks, PHV. I didn't even see the extra ampersand I had until I was comparing to your suggestions. Everything works and is happy now.

-Elysynn