Sorting appears to be case sensitive for text data sorted via query rules or the

When using a function, rule, or data type in an expression, remember that function and rule names are NOT case-sensitive, whereas data types ARE case-sensitive.

I think you've misunderstood my question. I'm referring to data that is displayed in a paging grid which in my case is stored in a database. I want to sort a list of objects in a paging grid by name, and have all names beginning with a particular letter grouped together. But names beginning with uppercase letters sort above names beginning with lowercase letters. I'd like all names beginning with either e.g. "P" or "p" to be sorted together.

Linda, the sorting you see is how text are usually sorted. If you want to achieve the way you want, you need to update your data to be of proper typecase. You can use the proper() function in Appian that may help you.

This can most probably be controlled at a database level. By default your RDBMS is probably set to use a Binary sorting method which is the quickest way for the database to sort but it is also case-sensitive. I know that both SQL Server and Oracle have parameters to control which sort method is used. You should speak to your DBA about this.