How to use Resident Where AND OR as below sample

[#1]

I keep the code as below, but the "where" condition doesn't working, who can help?

Thanks

Join(P_AUX)
Load
%ITM,
'Selecting' as SELT,
[UMCONV] as QTYS
resident ITEM WHERE left([Segm 3],2)<>'WF' OR [Segm 3]<>'STU' OR [Segm 3]<>'REJ' OR [Segm 3]<>'GOA' OR [Segm 3]<>'SVA';

[sparur]

do you have field [Segm 3] in the ITEM table?

[#3]

Is it possible that the problem is really in the P_AUX table, where you want to join this table (maybe there is a problem with field names) ?

BR, Miha

[#4]

All the records will pass the test because you use 'not equal' (<>) combined with OR.

Replacing the OR with AND will solve your problem.

Huub

[#5]

you are true man, thanks.