1. Add a field that will store the #
2. Run the query

SELECT 0000000000 AS SeqNum, &lcFieldList FROM ... into cursor CC  WHERE  &which

3. Open cursor R/W and replace SeqNum with RECNO()

SELECT 0
USE DBF("cc") AGAIN ALIAS ccsn
REPLACE ALL SeqNum WITH RECNO()

>
>How to put sequential (row) number in select counstruct like:
>
>SELECT &lcFieldList FROM ... into cursor CC WHERE &which
>
>CC ( 1, .. )
>CC ( 2, .. )
>
>TIA, gojko