I am inserting into a SQL table with "INSERT INTO...." and the table has an auto-increment ID field.

Is there any way that I can return that value within the INSERT call to the DB? Or do i have to do my INSERT and then a SELECT?

Thanks,
Kevin