The Like operator and wildcard characters - Automate_Studio - Latest

Automate Studio with Evolve User Guide

Product type
Software
Portfolio
Integrate
Product family
Automate
Product
Automate > Automate Studio
Version
Latest
Language
English
Product name
Automate Studio
Title
Automate Studio with Evolve User Guide
Topic type
How Do I
Administration
Installation
Overview
First publish date
2018
ft:lastEdition
2024-06-13
ft:lastPublication
2024-06-13T14:35:52.915393

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