Skip to main content

Is there a way to  sort the Delivery number Alphanumeric from for example 1 to 100. Now it sorts all numbers 1, 10 ,11, etc, and then 2, 20, 21 etc. This is very unclear. 

 

Hi Jchi,

I’m not very good with custom fields but when you use PL/SQL the code should look like this:
substr( CONCAT(TO_CHAR('00'),TO_CHAR(rel_no)) ,-2    )

The problem with different number lengths is very common.
(calendar weeks, calendar months, etc)
We solve that with “leading zeros” and the RIGTH function in MS SQL.
In ORACLE you have to use substring with a negativ number; here -2.
If you have 100 and above (not very probably) you can use 3 instead of 2 (digits).

Please let me know how to add a custom field with this code.
Good luck.
Michael

 

Reply


Terms & ConditionsCookie settings