Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-11-30 : 08:11:09
|
| Thuan writes "Dear SQL Team,I am a newbie to SQL and need some advice as to how to make a html textbox work with a sql like search.Actually, I don't know what exactly I am looking for... What I am trying to do is allow users to search a table's text column and return all row with the submitted keywords.I have honestly spent to last two days looking for such a tutorial but there are none. Please help.I am also trying to do all this using a stored procedure. Is this possible?Sincerely,Thuan V. Nguyen" |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-11-30 : 08:18:47
|
use 'like'example :where col1 like '%' + @keyword + '%'quote:
I am also trying to do all this using a stored procedure. Is this possible?
Yes. It is possible. Create a store procedure and pass the keyword in as a parameter.-----------------[KH] |
 |
|
|
|
|
|
html textbox and sql like search