>Is there a way to have a value that increments by one in a SQL statement?
>
>

>SELECT *, IncrementThisValueByOne FROM MyTable
>

>
>To get:
>
>

>MyFieldOne MyFieldTwo IncrementThisValueByOne
>
>Bobby      Jones      1
>Jamie      Lee        2
>Terry      Hatcher    3
>

SELECT *, RECNO() AS IncrementThisValueByOne;
FROM (SELECT * FROM MyTable WHERE ...) X