>I don't know if this will help...but T-SQL has a ROW_NUMBER function...
>
>
>select ROW_NUMBER() over (order by LastName, FirstName) , FirstName, LastName from NamesTable order by LastName, FirstName
>
Not really Kevin
thats the ROW_NUMBER() in the results not the row of the original data.(I think)
I'll have to sort out a proper key for the data and pass that.
Nick