--- In firebird-support@yahoogroups.com, "yartax1" <yartax@...> wrote:

>
> Hi,
>
> I want to do next query within a procedure:
>
> Select * from table where field_integer in ( :mylist )
>
> Where mylist is a variable with data as like as '123,345,342'. I
> suppose that fb considers field as numeric and commas are considered
> as decimal point.
>
> In any case how can I do a similar where clausule without doing
> another query or creating a temporal table? In a previous step I got
> field values and inserted in a variable, it would be more efficient
> that requery previous steps and join results with this new query.
>
> thanks,
>

Sorry by the subject, "IN operator" would be more suitable!