Add a column that stores the value for the first digit of a SalesLogix id.

Stored procedures to create SalesLogix keys or similar type functionality have to be updated everytime a new keytype comes out.

Here is an example:

-- Procedure Name: SPR_GetNextKey 
-- Date Created: 08/05/2004 
-- By: John Ostheimer - From code provided on CRM message board
.
.
.
SELECT @NewKey = CASE @KeyType 
WHEN 1 THEN 'A' 
WHEN 2 THEN 'O' 
WHEN 3 THEN 'C' 
WHEN 4 THEN 'B' 
WHEN 5 THEN 'V' 
WHEN 6 THEN 'H' 
WHEN 7 THEN 'E' 
WHEN 8 THEN 'n' 
WHEN 19 THEN 'L' 
WHEN 20 THEN 'Z' 
WHEN 21 THEN 'Y' 
WHEN 22 THEN 'a' 
WHEN 23 THEN 'J' 
ELSE 'Q' 
END

 Since this was released more key types have been added.  Most notiable is probably Ticket, 32.  Storing these values would eliminate a need to update 100's if not 1000's of deployed solutions when keyvalues are added.

If the new column is called KeyFirst this is what could be coded to obtain the value

declare @keyFirst char(1)

set @keyFirst = 'Q'

select @keyFirst = KEYFIRST from sysdba.SITEKEYS where KEYTYPE = 32