I am trying to take a multiple selection from a selection list and pass it to a SQL Server 7 stored procedure. In the case I am dealing with users are selecting years for which to view records. When I test the procedure by entering the values manualy the sql looks like: where Year in (1995, 1996) and things work fine. When I try passing the same value 1995, 1996 as a parameter I get the following message: Syntax error converting the varchar value ' 1995, 1996' to a column of data type smallint. I have tried all sort of data type conversions to get this thing to work and have had no luck. Any suggestions?