Subject Re: [IB-Architect] Syntax for case insensitive sort Kim Madsen 2000-03-29T18:35:46Z
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
FALSE.

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

just my 5 cents

best regards

Kim Madsen
kbm@...

--- In IB-Architect@onelist.com, 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
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