OK, if I want to compare two text strings for equality in a situation where case matters (i.e. is "abc" equal to "ABC"), I can use the Exact() function.
But how do I check to see if the first string is less than or greater than the second where case matters?
This test returns FALSE: "abc" < "ABC"
This test returns FALSE: "abc" > "ABC"
Both of the above return FALSE, because "abc" = "ABC" returns TRUE in FileMaker land ...
And, of course, Exact( "abc" , "ABC" ) returns FALSE, as expected.
So what is the analog to the Exact() function for comparing for less than or greater than with case sensitivity?
Thanks for any guidance ...