Getting autonumber from SQL Server

[reagent]

I'm using php 4.0.5 on Windows 2k and SQL Server 7. To connect to the database, I am using the odbc_* functions.

Is there any way that I can get back the autonumber value that was last inserted, like the mysql_insert_id() function?

thanks.
p.

[cheald]

I don't know SQL server, but try something like this:

SELECT id FROM table ORDER BY id DESC LIMIT 0,1

This will return the highest ID number.