>Can anyone tell me if MSSQL Server has a built in function to generate a unique character string? VFP, for example has the SYS(2015) function which generates a unique 10 character string based on the date and time. I want to create an insert trigger that will assign this unique string to a field as a default.
>
Paul,

Check a uniqueidentifier data type and NEWID function in BOL.