resident load where not like

[Anonymous]

Hi

I always made my resident loads with where Field1 like "Test".

No I want to make a resident load where Field1 NOT like "Test".

As the NOT is not right, do you know the right expression?

Thank you very much for your answers!

[alexandros17 · Accepted solution]

try

where not field1 like "test"

[#3]

Try Below:

Where NOT WildMatch(FieldName,'Test*')

[#4]

Hi Robert,

You can also try "Not WildMatch" function

wildmatch( M, 'ja*','fe?','mar')

Result: 1 as M = Januari

Result: 2 as M = fex