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
>NCASE).
>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