Subject Re: [firebird-support] Table Scans and !=
Author Paul Vinkenoog
Hi Daniel,

>>> 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 <>.

Thanks for the info. <> indeed 'fits better' in SQL.

BTW, IB/FB also recognize ^= (in C this means: lhs = lhs xor rhs) and
~= for "not equal". Pick and choose...


Grtz,
Paul