The Like operator and wildcard characters - Automate_Studio - 20.3

Automate Studio with Connect User Guide

Product type
Software
Portfolio
Integrate
Product family
Automate
Product
Automate > Automate Studio
Version
20.3
Language
English
Product name
Automate Studio
Title
Automate Studio with Connect User Guide
First publish date
2018
Last updated
2024-10-22
Published on
2024-10-22T07:54:52.852256

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