Alphabetical order of Name Column

[KristinBi]

Does anyone know if there is a way to change the alphabetical order of the name column so the words with capital letters don't come before the words that are lower case? We just want our titles in alpha order. Thanks Kris Kris Bishop Internal Marketing Agency • Securian Financial Group 400 Robert Street North • 12-3713 • St. Paul, MN 55101-2098 651-665-3713 kristin.bishop@securian.com • "http://www.securian.com/"> www.securian.com Securian Financial Group – Financial security for the long run ®

[Doug_Den_Hoed__AtAppStore]

Hi Kris, Behind the scenes, Workfront stores the data in an Oracle database, and it is the "https://docs.oracle.com/cd/B10501_01/server.920/a96529/ch4.htm">configuration settings on the database tht determine how sorting is applied -- to your point, treating a-z separately from A-Z. To override that behavior, consider trying to: control the input (e.g. use drop downs of known values), use a calculated parameter (e.g. UPPER(...)) to coerce everything into the same case, or use SORTASCSTRING(...) or SORTDESCSTRING(...) which I "https://support.workfront.com/hc/en-us/articles/217196767-Understanding-Calculated-Data-Expressions">just noticed tonight , but might also do the trick. Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads