> I would like to generate sequence number in SQL command, something like this > SELECT rownumber, field1, field2, ... FORM tablea ..
>
> I would like thar the rownumber start with 1 until the last number of the
> record
See also "How to dynamically number rows in a SELECT Statement",
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q186133hth
-Stefan