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