I am working with SQL Server 2000. I need to generate a unique 5 character code for use as a code that will be displayed to users on successful add of a new record.

I am too new to SQL Stored Procedures to know where to start. I looked at the MD5 add in stored proc but it returns 32 characters. I must have only 5. I thought about taking the identity number and converting it to hex, but I dont know how.

If some kind person out there would help me I would appreciate it.