Technology Training Community

A wildcard is a special character that can represent any character that may appear in the same position in the file. Common wildcards include the asterisk (*), the question mark (?), and the number sign (#). You may be familiar with using a wildcard along with the Like operator to help you locate records with similar data in your database. However, you might also find your database contains wildcards. For example, many times you will find that a database contains an asterisk in a field to indicate a special group. If you want to find a wildcard symbol that resides in your data, enclose the wildcard in brackets.

Example:
Use [ ] to match literal wildcard characters
Like "[*]*" will return records that contain a * and any additional text after the asterisk
Like "[*]" will return records that have a * in them