We have an AMPscript page using LookupOrderedRows() to create a list of resources ordered by the company name. I noticed that the list begins with a name starting with lowercase "a" then firms with numbers, then upper case "A", etc. Apparently LookupOrderedRows() sorts lower case then numbers then upper case? Am I correct? Is there a way to make the sort order ignore case for creating the rowset?
Unfortunately, you cannot directly do what you are trying to do via LookupOrderedRows(). That being said, there is a reasonably painless workaround, which I have used on multiple occasions. Do all your segmenting using Query Activities on this data extension, putting the results in a new data extension, in just the order you need them. Then you won't need to worry about case sensitivity.
Hope this helps.