Subject | Re: [IB-Architect] Syntax for case insensitive sort |
---|---|
Author | Jim Starkey |
Post date | 2000-03-29T18:19:20Z |
At 07:34 PM 3/29/00 +0300, you wrote:
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
>From: "Support" <kbm@...>So "ABC" is equal to FIELD1 ("ABC") and
>
>
>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.
>
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