The query is like :
SELECT MAX(EMPNO) + 1
WHERE EMPNO LIKE 'C%'
But here the field EMPNO is a character field. So adding 1 to this in the wuery is failing. Also I am selecting only Those EMPNO whose first character is a 'C'. So can anyone get me a solution houw to 1 one to the maximum value of EMPNO selected.
Like if the max value of EMPNO is C111223333, the value after addition should be C111223334.
Please let me know whether this is possible by making some changes to the query.