How does one use wildcards in SQL Reporting Services reports?
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. Terms of Use Privacy Cookie Preference Center