Not Match versus <>

[Adhi]

Can someone explain why I am getting different results depending on how the WHERE is written?

Table1:

LOAD *

FROM sales.qvd(qvd)

WHERE NOT MATCH(Status, 'removed');

Table1:

LOAD *

FROM sales.qvd(qvd)

WHERE Status <> 'removed';

NOT MATCH gives less rows compared to <>

[marcus_sommer]

I think I would add recno() and rowno() to the load to identify the different/missing records and could imagine that this result will explain the different handling of the methods (maybe NULL is also skipped).

[Or]

Match() is case sensitive, while <> is not case sensitive.

[Edit: No, they're both case sensitive. Oops.]

[tresesco]

@Or I did a quick test :

I did the similar testing in script as well. It (<>/=) appears to be case-sensitive.

[Or]

Huh. Re-testing it it seems you are right. Only = is case sensitive, seemingly. My bad.