When using a textbox filter type, what should you avoid including in your search term?

When using a textbox filter type, it is important to avoid including asterisks (*) in your search term. Asterisks are commonly used as wildcards in various search functions, often indicating a placeholder for zero or more characters. However, in the context of a textbox filter, using an asterisk can lead to unexpected results or errors, as the filter may not interpret it correctly and could fail to return any results at all.

In contrast, while wildcards like percentages (%) or underscores (_) might have specific uses in some database queries or SQL contexts, they do not typically cause the same issues within a textbox filter type as asterisks do. Numbers can also be included in search terms without causing problems, hence they are not something you specifically need to avoid. Understanding this helps to ensure that your filtering process works smoothly and effectively, maximizing the chances of retrieving the desired information.