On 9 Dec 2003 at 16:04, franciscoteuqat wrote:

>I want to know how to do or simulate a
>
>where fieldname in("opt1","opt2","opt3")
>
>but with a varchar parameters
>
>so in the stored proc, i want a things like
>
>where fieldname in (:paramstring)
>
>how you do that??

If you insist on double quotes and don't have them inside values,
try this:

where :paramstring like '%"'||fieldname||'"%'

Slow but work.

SY, Dimitry Sibiryakov.