> 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

I suspect that what it really wnats is a primary key value. Not just a
number which can change each time you retrieve the data. In which case you
should use the PK field. What visual component set is it?
Alan