Member Avatar for bettybarnes

hi can anyone please help me with the codes in search stored procedure..

for example.. i have combobox which lists lastname, firstname, pt_id, (the choices if i want to search for a particular record)

i forgot the code for search T.T

  • 3 Contributors
  • 2 Replies
  • 101 Views
  • 14 Hours Discussion Span
  • Latest Post Latest Post by bLuEmEzzy
Member Avatar for CodeWord

select * from table where field like '%<search term>%'

Use the percent sign (%) to show where the unknown is. If you know it starts with a word, the percent sign follows the search term. If you know it ends with a word, the percent sign comes before the search term. If the search term can be anywhere in the field value, put percent signs on both sides.

Member Avatar for bLuEmEzzy 
" SELECT yourfields FROM tbName WHERE Yourfields Like '%" & textbox1.text & "%' "
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.