Hey Mike,
>Hi Larry
>
>Esthetics aside, it seems to me there should be little or no difference in performance. The first query is fully optimized. The second query cannot fully optimize since there are no added indexes on the result of the first, right?
True. Although the way I had originally coded it, I had no optimization at all because I didn't use any filter expressions because it was looking at the whole table. It looks like you are now applying this algorithm to one part at a time which can be optimized using filters.

>
>I really got a chuckle out of your phrasing of *advanced* SQL. Are you studying diplomacy while JVP studies law <g>
>
>As for the code formatting, huh? Where do I find info on the formatting. Just what I need, another bloody programming language to learn <g>
One of life's many crosses to bear. *s*

>
>Mike