SQL and Parameter Sets
Posted on 2000-04-05
I have a table with three numeric fields and I am trying to return a result set based specific values of one of these fields.
SELECT * FROM table
WHERE (CAST(FIELD3 AS CHAR(2))IN :Parameter)
I can pass through a single value to the :Parameter looking like this (10) and it works fine. If I pass through (10,20) I get an empty result set. I have tried all the various forms of quotes and nothing works.
Please help. This is urgent.