thank you very much. I realized using SQL managment studio to generate these permit numbers is a lame idea. They can just use Microsoft Access form to generate these alpha numeric permits. They pick the value and then it generates the alpha numeric permits.

Thank you everyone.