Re: Using string variables in Select statements

On May 1, 4:07 pm, okumura-mik..._at_jvc-victor.jp 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.html http://www.williamrobertson.net/documents/comma-separated.html Received on Sat May 03 2008 - 02:22:11 CDT