this id?

[eluser]Tim Brownlaw[/eluser]
Well that's a whole lot different to your original post.

If that works for you, that's a way of doing it.

My only concern is if there is a race condition and two folks signing up at the same time get the same id.

I'm guessing you are trying to make the usernames unique so you could put a unique constraint on the username in the DB Table and/or perform a Select to ensure the username is not already taken and take the appropriate action.

It'd be very unlikely that there would be two identical usernames submitted that would end up having the same id... But not impossible.