• Select ColName From TableName Where [IdentityColName] = @@Identity

    ColName is the name of the column with the GUID and IdentityColName is your IdentityCOlumn.



    Something as incredibly simple as

    binary still gives you too many options

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!