Open your query in Design view. In the Criteria cell of the field you want to use, enter Like, followed by a pair of double quotes. For example: Like “”.

What is like in query?

The SQL Like is a logical operator that is used to determine whether a specific character string matches a specified pattern. It is commonly used in a Where clause to search for a specified pattern in a column. This operator can be useful in cases when we need to perform pattern matching instead of equal or not equal.

What is the wildcard character in Access?

Overview of Wildcard Characters in Access The asterisk “*” and the question mark “?” are the two main wildcard characters in Access you need to know. The asterisk represents multiple unknown characters. For example, the criteria “N*” would find all “N” words like “Nebraska,” “Ned,” “Not,” “Never Ever,” etc.