Like function

[#1]

Hi,

Does somebody knows what's wrong with my experssion?

Count (if(el4naam like '*HOOL*'= 0 and (Groep1='M10' or Groep1='M20'),MISTotaal))

Example

-------------

el4naam

***********

VAN HOOL NV

NMBS
ELECTRABEL

NETHERLAND VAN HOOL

=> I want to filter all values except VAN HOOL NV and NETHERLAND VAN HOOL

Grtz
Tim

[#2]

There is nothing wrong with the Groep1 part..

[swuehl · Accepted solution]

try

if( not FIELD like '*SEARCHSTRING*' and...

Nachricht geändert durch swuehl

[#4]

Perfect!

Thanks Sweuhl!!