I'm using whatever version of SQL Server that comes with VS 05. I think it's 2003. I can't seem to find a way to either make a column an identity but keep it type char and thus not have it increment or make a column accept only values that aren't already in that column. It seems like something someone would want to do pretty often (like if they wanted unique UserID's and Usernames) so there has to be a way to do it, right?