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!
where not field1 like "test"
Where NOT WildMatch(FieldName,'Test*')
You can also try "Not WildMatch" function
wildmatch( M, 'ja*','fe?','mar')
Result: 1 as M = Januari
Result: 2 as M = fex
Retrieving data ...