varying elements in IN list [message #37958] |
Fri, 08 March 2002 11:36 |
Neelam
Messages: 3 Registered: March 2002
|
Junior Member |
|
|
Hi,
I'm writing a function in which i'm passing an argument.Based on the value of this argument, i have to create a list of values of store it in a variable.
Then I need to use this variable in my select statement with IN operator.
Suppose based on my argument i have the values 'a','b','c'. I want to store these values in a variable and then want to pass it to my Select Statement.
So I want to use in my select statement as
Select * from trial where col1 in (variable);
How can i do it in a proper way. Please let me know. Its quite urgent.
Thanks in advance.
Neelam
|
|
|
|