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

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.

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.