>Howdy, y'all
>
>I'd like to T-SQL to MS-SQL to have it increment a field value and return that new value in one swipe - rather than hitting it twice (trying to eliminate the possibility of duplication).
>
>I suspect I can do a transaction - but I'm afraid that won't really work if someone else is incrementing the same counter at the same time.
>
>How can I do that?

text to m.lcCommand noshow
insert into ...
endtext

SQLExec(m.lnHandle, m.lcCommand)
SQLExec(m.lnHandle, "select @@identity",'lastIdent')

Cetin