Worked like a charm. I always seem to get myself caught up in trying to do everything in SQL, or worse, one SQL.

>Hmm, set-oriented SQL is not always the best choice for row-oriented logic like this. You might be better off sticking with xBASE:
>

>m.lnOffset = < some integer value >
>
>SELECT ;
>  MyColumnOne ;
>  , MyColumnTwo ;
>  , CAST( 0 AS I ) AS IncColumn ;
>  ...
>  INTO CURSOR Output ;
>  ORDER BY ... ;
>  NOFILTER READWRITE
>
>SELECT Output
>REPLACE ALL ;
>  IncColumn WITH RECNO( "Output" ) + m.lnOffset ;
>  IN Output
>