In SQL 2000 you can use XML. See
Re: Selecting records based on cursor values Message #
690890 for sample code.
>Trying to create a stored procedure to accomplish something like:
>SELECT * FROM TABLE WHERE CITY IN (@CITIES)
>where @CITIES is a parameter containing a list of cities: eg, 'Sacramento', 'Placerville', 'San Francisco'
>
>Any suggestions?
>
>TIA,
>Gary
--sb--