I&#039m mainly an Oracle developer and when we use sequences I would basically retrieve the next id by stating:<BR><BR>SequenceName.nextval into a variable<BR><BR>In SQL it&#039s called an indentity. My question is if I run an insert like so:<BR><BR>set myinsert = dataConn.execute ("insert into me (myname) values (&#039justin&#039)")<BR><BR>then somehow without writing a new select query, have the id number that was assigned. <BR><BR>I&#039m going to submit this in the Database Forum as well. Thanks,<BR><BR>Justin