Help with Syntax SQL Statement with Like and wildcards

  • Thread starter Thread starter Michael Turner
  • Start date Start date
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
 
Back
Top