awesome, that did the trick and it's cleaner. I was unaware that you could update CTEs directly. Always a bonus to learn something new.
Thanks Luis.
Bob
-----------------------------------------------------------------------------
How to post to get the best help[/url]