>Is there a way to add an incremental count expression while using SELECT statement. For example, the statement below retrieves record into cursor:
>
>

>select firstname from sometable into cursor
>

>
>the data retrieved is;
>

>john
>susan
>mary
>etc..
>

>
>Is there a way to write the SELECT statement where I can add a number for each record retrieved. For example:
>
>the desired data I would like to retreive is the firstname column and incremental number column (I don't know how to add something in SELECT statement to create incremental numbers);
>

>name column    incremental number column
>john           1
>susan          2
>mary           3
>etc..          etc..
>

>
>is there anything I can add in the SELECT statment to get incremental number column. Thanks
>

If you were in VFP 9, you could do with a derived table:

SELECT *, RECNO() AS nCounter ;
  FROM (SELECT <your actual query>) RealData ;
  INTO CURSOR NumberedResult

Tamar