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?
Question
Numerical Order
+9Is 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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.