How to search text in a table field?

[nzcncfan]

I could search from a table field any records containing "sale" using "sale*". However, is there a way that I could search any records DO NOT contain "sale" in the table?

Thanks

[vmoreno2605]

Searh the word 'sale', select it and then there is an option that says 'Select alternative' this will automatically select every possible option that does not have the word sale

[swuehl · Accepted solution]

If a normal search retrieves all values to exclude, then you can use a minus to exclude these

-sale

If the search to find all values you want to exclude contains a wildcard, you can get all excluded values using a compound search like

(* ^ "sale*")

[nzcncfan]

Thanks for your help!