smithmrk
asked on
In Statement
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.
SELECT *
FROM Table
WHERE smallint IN(@paramater)
How can I accomplish this?
Thanks,
Mark
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.
SELECT *
FROM Table
WHERE smallint IN(@paramater)
How can I accomplish this?
Thanks,
Mark
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, I'll give it a try!
FROM Table
WHERE smallint IN(@paramater)
if smallint is int field then parameter values like 1,2,3
and string then '1','2','3'