LIKE escape character sequence for wildcards

You can specify the character to be used to escape wildcard characters (% and _, for example) in LIKE clauses.

Note: Escape characters are not supported for Azure Synapse Analytics and Analytics Platform System.

The escape sequence for escape characters is:

{escape 'escape-character'}

where:

escape-character

is the character used to escape the wildcard character.

For example, the following SQL statement specifies that an asterisk (*) be used as the escape character in the LIKE clause for the wildcard character %:

SELECT col1 FROM table1 WHERE col1 LIKE '*%%' {escape '*'}