[RESOLVED] simple question about LIKE

[rheanunabia]

where do i put the *

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..

[leinad31]

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

[rheanunabia]

thank you

the code looks like this now

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