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.
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!