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
 
Top