How to pass a variable to a IN clause?
Posted
by
Thanu
on Stack Overflow
See other posts from Stack Overflow
or by Thanu
Published on 2012-10-29T04:55:17Z
Indexed on
2012/10/29
5:00 UTC
Read the original article
Hit count: 95
Lets say I have a SP that has a SELECT
statements as follows,
SELECT product_id, product_price FROM product
WHERE product_type IN ('AA','BB','CC');
But data goes to that IN
clause must be through a single variable that contains the string of values. Something link below
SELECT product_id, product_price FROM product
WHERE product_type IN (input_variables);
But its not working that way. Any idea how to do this?
© Stack Overflow or respective owner