--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:

>
> yartax1 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,
> >
> >
> Yartax,
>
> Have a look on the messages history, this kind of problem has appeared
> sometimes.
>
> One way is to use EXECUTE STATEMENT another is to parse the string in a
> loop and return each result set.
>
> see you !
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>

Thanks for your reply, Dimitry explained to me how containing operator
works. Is the best solution in my situation. Thanks you to remember
"execute statement" alternative, I missed it!

See you.
Yartax.