I am slightly confused by what you are aiming to do...
If you want one variable in which to search you could, in your script, try Var1 & Var2 as VarCombined then search for parts of VarCombined you are looking for.
But otherwise the statement you have above should work...For example in your script you could include:
(Wildmatch([Var1],'41','45','39','7000064','7000042') OR Wildmatch([Var2],'12','31','32','49','51'))
Would give you all results where Var1 or Var2 matched the parameters listed.
Otherwise are you looking to "search in" like a regular expression because that can be solved by
using wildmatch but using the * rather than the % in SQL. e.g. wildmatch([Var1],'70*') would give you all results starting in 70 with anything after it.
Hope this helps!
Well, I could do the things you mention but I don't have the access to the script (cannot edit it) and are not allowed to create any new variables so VarCombined is off limits as well. I've tried to filter on '1' in:
=if(Match([Var1],'41','45','39','7000064','7000042') OR Match([Var2],'12','31','32','49','51')),1,0)
but this doesn't work properly as well, as I think that the formula would have to be defined as a new variable for me to be able to filter on it.