Question:
How does one use wildcards in Quest Knowledge Portal and / or SQL Reporting Services reports?
Answer:
See 'Resolution' below.
SQL Server Reporting Services reports use SQL queries to generate data, these SQL queries use SQL wildcards, which are denoted as '%' and not as '*' that other platforms use might use.
- If you want to use search for all usernames that start with "Tom", you would search for "Tom%".
- If you want to use search for all usernames that end with "Tom", you would search for "%Tom".
- If you want to use search for all usernames that contain "Tom", you would search for "%Tom%".
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center