Using Like in SQL Statement

[gknierim]

REMOVE the '=' after Name. STRONGLY CONSIDER USING a different fieldname other than Name as it is a RESERVED word.

ALSO, unless you are searching for an '*' in the name, REMOVE IT! The * is not a wildcard character, the % is.


'This part I cannot get to work
'da.SelectCommand = New OleDbCommand("Select * from Customers Where Name= Like '%" & Me.txtSearch.Text & "*" & "%'", ocon)
da.Fill(ds)


Your code should be this:
da.SelectCommand = New OleDbCommand("Select * from Customers Where SomeName Like '%" & Me.txtSearch.Text & "%'", ocon)

HTH,
Greg