Numerical Order

SMcLees wrote:

Is there a way to change how the numerical order in some fields works?  For example when I order the below column, ifs orders it by first digit, then second.  How can i get this to be ordered 1 - 26 and not as it below?

 

 

Hi,

If you check the database view of this table you will see that line no is defined as a VARCHAR2 column.

So, you can’t order it by Line no since it isn’t a Number field. But I can suggest you a workaround. Create a custom field by converting the VARCHAR2 to Number field. Then you will be able to sort the table view by newly created line no.

BR,

Kavindu