Subject Re: [IB-Architect] Syntax for case insensitive sort
Author Kim Madsen
Ehh.... break what???

Its really not that difficult. You either compare with constants or
with fields on left and right side of the operator.

If you compare constant against a field, the constant ofcause must
follow the rules of the field to be matched as TRUE.

That ought to be simple logic.

If the field is a UCASE field the constant should be converted to
UCASE before comparison, if the field is NCASE, the constant should
NOT be converted, but used as is and in the example shown result in

If two fields are compared, the rules I wrote before should be

just my 5 cents

best regards

Kim Madsen

--- In, Jim Starkey <jas@n...> wrote:
> 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
> >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