There is not a good way to do it with the default interface. (I think it's
coming with SQL 2005, though.)

Possible workarounds are:

* Build a custom user interface. See the samples that come with the
product.
* Have a text box and allow free-form entry (comma-separated). This is a
difficult one for users to get right, and works best when your input options
are integers.

With either of these, your SQL might be structured like so:

WHERE FieldName IN @Parm

--
Cheers,

'(' Jeff A. Stucker
\

Business Intelligence
www.criadvantage.com
--------------------------------------
[quoted text, click to view]

how can choose more than one parameter in one parameter

ejemp

id name
1 a
2 b
3 c
4 e

I would like can choice 1 and 3 and 4 and same time.

thanks