Hi Jim,
_TALLY will always give you correct result. RECCOUNT() will give wrong result if a cursor is created as a filter on the source table.
>My example was merely that -- an example. As I had need for the alias later on in my program, this example merely demonstrated that the alias disappeared.
>
>In any case, I think it odd that _tally would be considered "the right way". There doesn't seem to be any explicit reason in the language itself for this preference, so I'll assume there is some implementation dependency I am unaware of.
>
--sb--