exclude data

[#1]

My syntax does not work. I still get everything but I want to exclude everything with MutatieType_ID 173

WHERE

("MutatieType_ID" <> '173' or "MutatieType_ID" <> '152' or "MutatieType_ID" <> '204');

I have also tried:

WHERE

("MutatieType_ID" <> '173' and "MutatieType_ID" <> '152' and "MutatieType_ID" <> '204');

Both do not work.

Can anybody tell me whats wrong?

[#2 · Accepted solution]

Hi Richard,

try it without apostrophe (MutatieType_ID <> 173).

Rainer

[#3]

remove " (double-qoutes) around the MutatieType_ID fieldname

[#4]

Thx, it works. Weird thing though, because first I have to load it WITH the apostrophe and in the where-statement it's without.