Subject Re: [IB-Architect] Syntax for case insensitive sort
Author Jim Starkey
At 07:34 PM 3/29/00 +0300, you wrote:
>From: "Support" <kbm@...>
>Rules of comparing strings would be to convert from less restrictive case
>to more restrictive on comparison:
>Comparing FIELD1 ("ABC") and FIELD2 ("abc") would result in TRUE because
>FIELD2 is compared with FIELD1 and FIELD2 is less restrictive (defined as
>Comparing FIELD1("ABC") and FIELD3("abc") would result in FALSE since they
>are equally restrictive.
>Comparing FIELD2("AbC") with "ABC" would result in FALSE.
>Comparing FIELD2("AbC") with "AbC" would result in TRUE.

So "ABC" is equal to FIELD1 ("ABC") and
FIELD1 ("ABC") is equal to FIELD2 ("abc") but
"ABC" is not equal to FIELD2 ("abc")

I believe you have broken one of the most basic laws of logic.

Jim Starkey