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
select Id from example where Name like '%" & txtBox.Text & "%' "
Hope this helps.