OK, So I want to use an IN Statement against a smallint field.
How can I pass in the Paramaters so they work against a smallint field?
For example I want to pass in "1,2,3" as a paramater and have the 1,2,3 go against a field in the database that is a smallint type.
WHERE smallint IN(@paramater)
How can I accomplish this?