How to make unique, readable, varchar codes in a Guid ID table

[Sir Dot Net]

So I have a table Invoices with ID type Guid. But the user wants to have a unique, human-friendly code, to go along w/ each row. Any good suggestions on how to implement this? Should I have the client app check->generate->update, or should I have some sort of scalar function generate this (auto-compute column value). Maybe a trigger? Thoughts appreciated. (running mssql'08)

[Mycroft Holmes]

Keep you guid as the primary key (I hate guids) and add a CustomerCode field, populate the initial set of data according to the clients needs and let the operator manage the code from then on. NEVER and I mean not once do you use this field for anything but human UI searches, continue to use the guid as the key constraint for you data.

[i i i]

try this http://www.yafla.com/dennisforbes/Sequential-GUIDs-in-SQL-Server/Sequential-GUIDs-in-SQL-Server.html[^]

Best Regards, SOFTDEV If you have knowledge, let others light their candles at it