Hi, is there a way to have a RowNumber for each row returned by a
query?

like: select RowNum(), fld1, fld2 from MyTable order by 3, 2

I know this is probably not good SQL, but the 3rd party visual
component I'm using expects a numeric ID from the dataset.

FB103

Thanks Q