I did a filter on some names, some of which started with "A" or other capital letters, and some of which started with "a", where the filter expression was:
name > 'a'
It selected all of those names. If that was case sensitive, like I thought DW expression comparisons on strings were supposed to be, it would have excluded all of the ones that started with capital letters, since they are lower in the ASCII order (or Unicode code point order) than capital letters.
Certainly if I use = in a comparison it is case sensitive.
Basically that filter seemed to be behaving as if I had used:
Upper(name) > Upper('a')
Is this expected behaviour? A bug? Something I don't understand about Unicode characters?
To perform comparisons in ASCII order, append "\s" to the format string. For example, the following expression shows only rows in which column 2 begins with a or b, because the ASCII values of uppercase letters are lower than the ASCII values of lowercase letters:
#2 >= 'a' and #2
#2 >= 'a' \s