>>Sometimes SQL is not always the answer. Although it is possible to do what you want with a function it would probably be easier to add a column for what you want and do a simple SCAN ... ENDSCAN to fill in the value of your counter.
>
>You could also add the following to the fields section of your SQL:
>00000 as ArbitraryCounterField
>
>The use: Replace ArbitraryCounterField with RecNo()
>
>This assumes the record number is sufficient to mark the records. If you need an ID based on some data, then you might need to use Scan..EndScan.

I don't think I can use Replace on a cursor, but I think after the cursor is created the query can be run again against the cursor adding that field and using RecNo( ), also using NoFilter.