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
bettybarnes
7
Posting Whiz in Training
Recommended Answers
Jump to Postselect * 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 …
All 2 Replies
CodeWord
6
Junior Poster in Training
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.
bLuEmEzzy
0
Junior Poster in Training
" 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.