Negative Expression?

[Anonymous]

hi

i have a column that is a list of letters  (A///A,B///A,C,B,,,etc)

so i can do dropdown select and say *A* so i can select all the rows that contain the A letter..

how can i with dropdown select do all <> *A* or not contain A

how do i do that as an expression

thanks

[Chanty4u]

may be try

with your requirment

=wildmatch(FIELD,'*A*') and not wildmatch(FIELD,'*B*','*C*)

[Digvijay_Singh]

Try this may be -

(*^A*)

[tamilarasu · Accepted solution]

Hi Jackie,

Try: (*^*A*)

Compound Search - demystified

[Anonymous]

this works perfectly thank you

thanks all