Help with Syntax SQL Statement with Like and wildcards

M

Michael Turner

Hi

Can anyone help me with my syntax please. This is not working.
Set rs = conn.Execute("SELECT * FROM tblCompany WHERE company like '*" &
txt_search & "*';")

Thanks in advance

Mick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incorporating the User Profile location into a document template path 1
Help with Syntax using SQL Statement with Like and wildcards 3
Help with Syntax using a Select statement with Like and wildcards 2
WordBasic to VBA conversion 3
Wildcards in SumIF formula 1
Office365 Family + TXT or MX Domain 0
Nested dynamic SQL Query Question 2
stlinkcriteria syntax. multiple fields and wildcards 5

Top