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 |
Sun Foster
Aged Yak Warrior
515 Posts |
Posted - 2006-04-29 : 08:38:02
|
I created a search program use Variable (VarModel, get value from text box) and like as bellow:... where Model like 'VarModel%'It works fine.Now, I need add 3 text boxes to assign to 3 variable, Var1, Var2 and Var3, how to make where clause?I knew that clause like bellow will not work:... where Model in (like 'Var1%', like 'Var2%',like 'Var3%') Can someone show a way to get same result so that user can input '%' in three input boxes to search? |
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-04-29 : 09:11:51
|
how about this ??Where (Model Like 'var1%' OR Model like 'var2%' OR Model like 'var3%')??If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
|
|
|
|
|