i have used a char field length 10 in my ztable as gate pass no.
also created a module pool which generates gate pass no.
select max(gatepass no) from ztable into var.
it select 9 as max however maximum gate pass no currently present in ztable is 10.
also when i sort my ztable in ascending:
it sorts like this:
instead if i use numeric in case of char then gate pass no generates like this 0000000009. after condense statement.
suggest some solution.