Question:
We need to include or exclude certain records based on a text pattern buried in a longer text field.
Ex.: Find "XXX" in "1234XXX5674323".
What is the correct way to specify this in the query?
Answer:
*XXX*
You can also make this a variable selection of the type "Contains Pattern" and then your users will be prompted to enter in the pattern (in this case XXX) and they won't have to remember to enter in the "*".
- Stephen