>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.
If it's not broken, fix it until it is.
My Blog