|
Sun Foster
Aged Yak Warrior
515 Posts |
 Posted - 04/29/2006 : 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?
|
|
In statement with like
