using wildcards in query
I'm trying to query all records where the record "contains" a certain keywords; a multi-wildcard query. Problem is, I have to type them all into the filter every time in case the data changes after the ETL runs. I want to run this as a canned report.
What happens is I apply my "contains" filter to the row and the search shows me which records are found. This is fine, but what happens when the database gets updated? I will have to go into the criteria again and type in all my wildcards.
Can't I create a query so my wildcards will be remembered and pulled dynamically? Perhaps there is a better way to do what I'm doing. This seems pretty fundamental stuff but I can't find a way around it. thanks for heping in advance!
What happens is I apply my "contains" filter to the row and the search shows me which records are found. This is fine, but what happens when the database gets updated? I will have to go into the criteria again and type in all my wildcards.
Can't I create a query so my wildcards will be remembered and pulled dynamically? Perhaps there is a better way to do what I'm doing. This seems pretty fundamental stuff but I can't find a way around it. thanks for heping in advance!