I need to generate a unique job number for each record which should be alphanumeric. I can't use autonumber because it generates only numbers. How do I go about it?
Alphanumeric means, that alphabet character comes from where? its like first character of employee's Last Name or else? If you want to reset that autonumber for each character or continues number?(i.e., irrespective of character)
Send me answer for my questions.I hope its possible.
Alphanumeric means, that alphabet character comes from where? its like first character of employee's Last Name or else? If you want to reset that autonumber for each character or continues number?(i.e., irrespective of character)
Send me answer for my questions.I hope its possible.
":-) IT Knowledge is power :-)"
Thanks for the quick reply. It will be 1 character (most probably J) followed by the number. All I need is a unique number and doesn't matter if they are continuous or not.
Why bother at all with the character in the base table if is going to be a constant?. Use an IDENTITY column, then create a view that converts the number to a string and then add whatever characters you like. The users won't know the difference.
Why bother at all with the character in the base table if is going to be a constant?. Use an IDENTITY column, then create a view that converts the number to a string and then add whatever characters you like. The users won't know the difference.
DavidM
"SQL-3 is an abomination.."
Good idea! I am using VB as my front-end. What I'll do is display the character along with the generated number in the text field. Thanks again!
Unique Job Number
Posted - 11/29/2003 : 03:22:43
