vbnetcoder
asked on
plus 1 to key
I have a field like this with values like this: NJ001013205. there are all the same length starting with NJ and then the numbers. how would I get the mad field + 1
so, if the max value was this NJ001013205 I would return NJ001013206
so, if the max value was this NJ001013205 I would return NJ001013206
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ty
Open in new window
Output
Open in new window