[RESOLVED] simple question about LIKE

where do i put the *

Code:

---

adodcBranchGrid.RecordSource = "SELECT * FROM branch_tbl WHERE branch_name LIKE'" & txtBranchFind.Text & "'"

---

what i wanted was when i put c in the textbox it would retrieve all the data that start with c..

Try searching http://msdn.microsoft.com/en-us/libr...2(SQL.80).aspx

thank you

the code looks like this now

Code:

---

adodcBranchGrid.RecordSource = "SELECT * FROM branch_tbl WHERE branch_name LIKE'%" & txtBranchFind.Text & "%'"

---