Hi List, can I inside a stored procedure say: declare lastid long lastid = insert into aTable (x,y,z,...) Will insert return the inserted record recid ? Or how else can I obtain the last inserted recid (always inside a Stored procedure) Thx Bart PS: damn, your response keep coming quicker then I can make up questions :-)