Alphabetical Sorting Order

What is the exact logic of the alphabetical sorting on fields?  I have a field called advertiser and find that it's sorting by upper case, sentance case then lower case.  Is this what it's doing??  I need it to sort alphabetical regardless of case.

Comments

  • Hi @user04669!

     

    That is likely what's happening here, is that it's sorting cases in addition to alphabeticals. 

     

    What you can do as a possible fix for this is to create a simple beast mode that looks like this:

     

    LOWER(`Your Column Here`)

     

    Then go ahead and sort by the newly created beast mode and see if that fixes the sort issue. 

     

    Hope this is helpful!

This discussion has been closed.