I am trying to figure out a way in Access / SQL Server to run a SELECT that adds an auto-incrementing column.<BR><BR>Like this:<BR><BR>Table:<BR>test<BR>----<BR>col1<BR>----<BR>entry1<BR>entry2<BR>...<BR>entry1000<BR><BR> My SELECT results should look like this:<BR><BR>rownum &#124 col1<BR>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#124 entry1<BR>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&#1 24 entry2<BR>...<BR>1000&nbsp;&nbsp;&nbsp;&#124 entry1000<BR><BR>Basically, I would like to emulate the rownum feature in Oracle (because my client is migrating from SQL Server to Oracle and I would prefer to write code that will work with both, wherever I can).<BR><BR>Thx,<BR>Kurt