Wildcards

The % symbol is used to represent wildcard characters in search fields, allowing users to perform flexible and partial matches. Here's how the % symbol can be used as a wildcard when you are searching for specific data: A% → Matches any string that starts with "A". %1 → Matches any string that ends with "1". %A% → Matches any string that contains "A" anywhere in the value. Search values are not case sensitive, can search for any value, and can be used on any column that allows filtering.