```osquery> select "aa" > "AA", "aa" > "A...
# core
s
Copy code
osquery> select "aa" > "AA", "aa" > "AA" COLLATE NOCASE;
+-------------+----------------------------+
| "aa" > "AA" | "aa" > "AA" COLLATE NOCASE |
+-------------+----------------------------+
| 1           | 0                          |
+-------------+----------------------------+
Not sure if that’s better than
version_less(x,y)