>Or...
>
>If you're into SQL statements...
>
>Select * from table1 where a=b ;
>Union All ;
>Select * from table2 where a=c ;

>
>Will
Hi All,
Thanks for the quick replays !!
I used Tim's solution, only changed the scatter/gather into copy to array/append from array because I needed to copy multiple records.

Will I can't use your solution because I do not know the number of unions I'll need to do because it is data dependent, so the use of a temp cursor is the best solution for me ...

Thanks again...!!!

Gadi Hutt