Double where clause?

[#1]

Hi,

I am trying to create a Load Script, where I need to filter out some results.

I was trying to use:

where not "COLUMN A" = 'UDM' or 'UDT' or 'UDTR'

It will work if I have 1 criteria (UDM for instance), but as soon as I add more it only returns first value.

What am I doing wrong?

I would like to do something like this:

If you have a list, say

A

B

C

D

E

F

G

H

I

Then I am trying to load all data except A and C, which I would write as load all and then use Where not A or B

[swuehl]

Try

...where not match(FIELDNAME,'A','C');

[jagan]

Hi,

Try this

where [COLUMN A] <> 'UDM' OR

[COLUMN A] <> 'UDT' OR

[COLUMN A] <> 'UDTR'

Hope this helps you.

Regards,

Jagan.

[#4 · Accepted solution]

That will give me 390.063 records instead of the 142.941 I had already. The extra clauses should give less results instead of more.

But actually I replaced your OR with AND and now it works.

Thanks