DECLARE @i int, @key int, @Base36 char(36), @Key5 varchar(5) SET @key = 1234578910 SET @Base36 = '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ' SET @Key5 = '' SET @i = 1 WHILE @i < 6 BEGIN SET @Key5 = SUBSTRING(@Base36, (@key % 36)+1,1) + @Key5 SET @key = CAST(@key / 36 AS int) SET @i = @i + 1 END SELECT @Key5>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.