Brian,

Sorry for my late comment but I was busy that week & I never looked back in on this discussion & I missed your comments.

You suggest that

quote:

For example:
INSTR("abc","A") = INSTR("abc","") = 1 should NOT be true.
Why? Looking for "nothing" fundamentally violates the logic system so why couldn't it return an illogical answer.

I agree my patch or constraint on the logic doesn't resolve all the logical conflicts but I am not sure that there is any constraint that is logically consistent in every circumstance.

A point:

If ""="" is true would it be logical to have INSTR("","") be false?

I don't think there is a logical answer to this debate & Ruud's reason is as good as any.

[ 24. August 2002, 05:27: Message edited by: Jack Lothian ]
_________________________
Jack