Help Center>Studio v11 (Foundation)

The Like operator and wildcard characters

You can use the Like operator with wildcard characters to expand your query.

Single underscore or question mark

a_ or a? returns records for values like a1, a2, and ab, but not a12 or abcd. You can use any number of underscores to represent the number of characters you want to match.

Percentage or asterisk

a% or a* returns all values that start with a, followed by any number of characters. For example, it matches a1, a2, ab, a12, and abcd.

Tip: To query for data that includes an underscore character, use an escape. For example, to find all material numbers that begin with Z_, use the query string Z~_%'ESCAPE'~.