I have the following SQL Statement:
SELECT TOP 1 MORTGEE_NUMBER FROM MORTGEE ORDER BY MORTGEE_NUMBER DESC
This returns the highest "AutoNumber" in my table - MORTGEE.
I would like to add one to this number, via sql if possible, or any other suggestion. This is an integer.