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?
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
If a normal search retrieves all values to exclude, then you can use a minus to exclude these
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*")
Thanks for your help!
Retrieving data ...