The dimension is loaded from an oracle database to a QVD.
The QVD is then used in my app.
Where are you referring when you say, real alphanumerical order?
1) the original table in the Oracle database via key value
2) the app that loads the Oracle DB to the QVD via "Order by"
3) the app that displays the straight table via "Order by"
Your second response references dual value.
I will research that and see what I can do.
Lastly, I read a response from you on the topic of sorting alphanumeric where you tell the user to put a "|" pipe between each character then show the non formatted field but sort by the field with the pipe, separated characters. I started that process, I have the non formatted field and the pipe, separated field but I don't know how to tell the straight table show one but sort by the other.
.png "Former Employee"){kind=icon}