Subject | IN function |
---|---|
Author | yartax1 |
Post date | 2007-02-05T15:54:30Z |
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,
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,