Thanks for the SCOPE_IDENTITY() suggestion. I inherited some code and didn't look into it deeply. I'll check out the function.

I put a request on a Sybase newsgroup and I'll keep checking for replys. Sybase, as community, doesn't seem to be as active as MS SQL Server and VFP.

Gary

>is IDENT_CURRENT() what you really want? It returns the last IDENTITY value inserted into the table, regardless of the connection that inserted the row! IMO, you probably want to use SCOPE_IDENTITY().
>
>Sorry, can't help you with Sybase. Have you check any of the Sybase newsgroups?
>
>-Mike
>
>>Hi,
>>I'm modifying a VFP program that runs against MS SQL Server to run against Sybase 11 because, unfortunately, that what a client uses. I use "Select newkey = IDENT_CURRENT('warranty')" to get the ID of a newly INSERTEd record. Does anyone know if a Sybase analog exists? Thanks.
>>
>>Gary Foster