Using string variables in Select statements

From: <>
Date: Thu, 01 May 2008 11:07:03 -0400
Message-ID: <>

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.

	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. Received on Thu May 01 2008 - 10:07:03 CDT

Original text of this message