ILike (Aster Database) - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
gxn1538171534877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

This predicate is only available when connected to an Aster database.

The ILike predicate is supported, either with pattern expressions or with subqueries. The percent (%) or underscore (_) characters can be used to allow searching for a pattern. The percent character represents zero or more characters of any value, whereas underscore represents exactly one. An “escape” character may optionally be specified to allow searching for patterns that include a percent (%) or underscore (_) character by placing an escape character immediately before either of these characters.

Variable Creation > Input > Variables: SQL Elements pane - Logical > ILike

Columns and/or other expressions can be moved into the (empty) branches of the tree, where the first argument is the expression to the left of the LIKE and the second to the right. The subquery element is found in the Other - Expert category of SQL Elements.