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.


  • PodiumMason

    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!

    **Say 'Thanks' by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem as 'Accepted Solution'
This discussion has been closed.