Help with Syntax using a Select statement with Like and wildcards

[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

 

[John Henriksen]

Hi Michael

Are your connection to an SQL server then Use % instead of *

John

 

[Dan Artuso]

Hi,
The wildcard when using ADO is %, not *