how to select a record and delete from table afterwards?

[wataru]

is it possible to retrieve a record and delete it from the table afterwards,
in a single sql statement?

right now, i'm doing it in 2 separate sql statements:
1. select * from table where idNum = 1 (store it in a record set variable)
2. delete from table where idNum = 1

i was wondering if i could execute it in a single sql statement.

thanks,
joe