[thelist] SQL 2000 auto create ID's

[Ingrid Z]

This list is such an awesome resource.
I was thinking days of struggling, (which may still happen anyway), but you
are getting me on the right track.
I think asp is definitely the way to go.
I really appreciate all your help and ideas, always !!

Ingrid

> SQL 2k cannot do this well, but there is another option which I have used
> over time. Your scripting language can do the creation for you, here is an
> example in pseudo-code
>
> //--variables received from registration form-->
> $userName
> $anotherVariableA
> $anotherVariableB
> // create user ID
> $prefix == "AB"
> $initials == "process to extract initials from $userName"
> $randomNumber == "math to get a 5 digit wide random number"
>
> $userID = $prefix concatenate $randomNumber concatenate $initials
> so therefore $userID would be something like AB020359JB
>
> Do something similar with the password.
>
> HTH!
>
> Jay