Sorting Issue in a repeating grid column Age, Column type as Varchar2 in DB
I have a property Age as VarChar2 in Database, we are using a RD to fetch records from DB and showing it on a Repeating Grid UI.
Now the Age is not sorting properly if Age<10 i.e. if there are Ages 1,5,10,20,40,60,45 and i would like to sort them in Ascending order it may show as below
10, 20, 5,40,60,1,45
I know the solution that we can modify the DB column type to Number and it should fix the issue but i want to know of any alternative approach wherein i can make modifications in the RD which resolves the sorting issue.