Hi, i'm a new programmer and i'm learning VS 2005 VB by myself and I've loads of questions to ask.

My question is to how to auto increment my reference number with char(9). I'm creating a web request form where users will enter all their information on the form and when they click save all data will be stored in a database. I realized that I can't use IDENTITY in my stored procedure to auto increment my reference number.What other ways can I use?

Please help.:cry:

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.