how do you select an autonumber datatype when inserting a new row

[Steve]

Does anyone know how to select an incrementing datatype while inserting a
new record using one sql statement?

[Mehdi Mousavi]

Take the row that contains the greatest autonumber, by calling
MAX(yourAutoNoField)
or
Take the newest row that is inserted to the table, by processing its date of
insert

HTH,
Mehdi
--
Got a question about modems? Take a look at http://www.modemmania.com
"The important thing is not to stop questioning. -- Albert Einstein"


"Steve" <steve_woodcock@med3000.com> wrote in message
news:3a1be8e7@news.devx.com...
>
> Does anyone know how to select an incrementing datatype while inserting a
> new record using one sql statement?