Using Like in SQL Statement

[Maurice Sanders]

Use it as follows:
Instead of the * character use % character and no = character in front of the like operator.

da.SelectCommand = New OleDbCommand("Select * from Customers Where Name Like '" & Me.txtSearch.Text & "%" & "'", ocon)

I hope this helps.

Regards,

Maurice