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 |
|
midpenntech
Posting Yak Master
137 Posts |
 Posted - 2009-05-06 : 09:26:32
|
| I am using an @ function but i need to be able to pick multiple items. as of right now its (Constructionmaster.kmfg = @kmfg) i understand the = is only 1 item. what would I use to get to choose 3 to 4 items. |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-05-06 : 09:35:03
|
| what do you mean by @ function?if you want to include multiple values...u have to use "IN"Constructionmaster.kmfg IN (@kmfg,@kmfg1) |
 |
|
|
midpenntech
Posting Yak Master
137 Posts |
Posted - 2009-05-06 : 09:38:05
|
| That is exactly what I was looking for. I understood that it should have been a IN but did not understand that you had to add a value for each one after. aka kmfg, kmfg1, kmfg2 and so on. |
|
|
|
|
|
|
quick easy question