Hello there,
the like statement will match the substring in your database you have specified in your query.
suppose you want to extract data from
example table and you have a text control
txtBox where you have entered into the account number/ name or any thing you wish and wanna select
Id of that selected record then use the following query
Code:
select Id from example where Name like '%" & txtBox.Text & "%' "
Hope this helps.