I have an asp website that is used for entering invoices. For the invoice number, I need to pull the highest invoice number from the database so that I can add 1 to the number part and use it for the newly entered invoice. The invoice number is in the format: G-111. How can I pull the highest invoice number from the SQL database so that I increment the invoice numbers correctly?
Thanks for all of your help.