Thank you Jeff, that is what I have been leaning to as well. Seems to just make the process that much easier.

Sorry it took awhile to reply to everyone was out of town for the weekend. What I am doing is trying to create userids from a database which we...

Thanks Jack this is what I was looking for and I am now able to make sure each id is unique when making userids by combing year, last name, first...

Here is what I am currently trying but I am having issues with it. First time trying a loop in SQL:

DECLARE @i INT

DECLARE @id VARCHAR(64)

DECLARE @newid VARCHAR(64)

DECLARE @count INT

SET...

I do not currently have the check feature. I am using this to create the ids

insert into _userid

Select Left(p.usernumber,2) + i.lastname + Left(i.firstname,1) + COALESCE(Left(i.middlename,1),'') As userid

from dbo.person p,

dbo.id...