The Like operator and wildcard characters - Automate_Studio - Latest

Automate Studio with Studio Administrator User Guide

Product type
Software
Portfolio
Integrate
Product family
Automate
Product
Automate > Automate Studio
Version
Latest
ft:locale
en-US
Product name
Automate Studio
ft:title
Automate Studio with Studio Administrator User Guide
Copyright
2025
First publish date
2018
ft:lastEdition
2025-03-13
ft:lastPublication
2025-03-13T04:55:08.662000

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'~.