by William Robertson <williamr2019@[EMAIL PROTECTED]
>
May 3, 2008 at 12:22 AM
On May 1, 4:07 pm, okumura-mik...@[EMAIL PROTECTED]
wrote:
> I am attempting to use a variable in the WHERE clause of a SELECT
statement.
> How would one pass a value for an IN statement, ie.
>
> SELECT *
> FROM inventory
> WHERE color IN ('red','green')
>
> If I replaced the last line with
>
> WHERE color IN (v_color)
>
> How would I set it?
>
> v_color := '"red","green"'
>
> doesn't work.
http://tkyte.blogspot.com/2006/06/varying-in-lists.htmlhttp://www.williamrobertson.net/do***ents/comma-separated.html
