You could generate it in the original SQL statement. Use a temp table with
an identity column, and fill it with the original data, and then select from
the temp table.
Jeff
"Glenn" <gl**********@bt.com> wrote in message
news:11**********************@y43g2000cwc.googlegr oups.com...
I have a grid view which takes its data from an SQL query.
The query returns a league Table of results. I would like to a add a
column which show the poistion of result (i.e 1,2,3,4)
how can i get add a column which simply showns an incremented number
for each row.