Sql Anywhere does use temp tables and cursors. I have always avoided cursors because they tend to be slow. My problem is with the @i counter. Sql Anywhere does not like it.

Thanks.

>>Thanks Naomi,
>>
>>I am having a some trouble adapting the syntax to Sql Anywhere but it gave me some ideas.
>>
>You're welcome. Does Sql Anywhere have temp tables concept / cursors? There was another solution in the mentioned thread using CURSORS, but I think temp table solution with this interesting UPDATE is much better.