jamesdean666
asked on
Addition functionality in SQL Statement?
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.
THanks,
JD
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.
THanks,
JD
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER