how about an Identity using a bigint column that starts with the first 16 digit number ?
create table #example( bigintID bigint identity(1000000000000000,1) primary key,
morestuff varchar(30) )
also why must it be 16 digits?
::editing i just saw it needs to be letters and numbers...i have an example, but it is still based off of an identity column::
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!