Using Like in SQL Statement

[q582gmzhi]

Hi,

I am trying to use the like statement in an SQL statement but I am unable to!

This works without the "Like" command:

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

This is what I am trying to get to work:

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

Any Idea's

Darrell....