can anybody tell me how to generate unique numbers say of 5 digits each starting with the letter C? I have a form where i want to generate a code in a textbox for one product when i click on the generate button. not random numbers but in ascending order starting from say C0001 or something like that.
Pls help me. I gotta finish this database project soooooon!