I am trying to set up an advance filter on a column i have created which shows either Not Equal to, Equal to or Matches Pattern.
All of which are set to <string>
I want to do as a range, CT_A CT_B etc... or by 111222 111221...
I am probably missing something quote fundamental, however I have used a comma, a &, the word and, the word or and none of theme seem to work, however if I put the string in individually or leave it as any i get the data.
As always any and all help greatly appreciated.
You can't do a range. The closest you can get to that behavior is to use "Matches Pattern".
If you do Matches Pattern: CT_
You end up with SQL like: WHERE columnName LIKE '%CT_%'
Your other option would be creating a custom Value List to apply to the column.
Cheers Jameson I have used the Matches pattern as thankfully what I need to advance filter on all started with the same prefix...