Hi,

At August 4, 2003, 21:35, Paul Vinkenoog wrote:

>>> Is it pretty common knowledge that != on a field always does a
>>> table scan?
>>
>> No!
>>
>> In fact, what does != signify? Not equal?

> Yes, !- means the same in C as <> in Pascal. Both are recognized by
> IB/FB. Kind of weird, actually. (I wonder if both are standard SQL?)

Actually the not equal operator in the SQL standard is <>.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)