skip to main content
SQL Escape Sequences : LIKE Escape Character Sequence for Wildcards
 

Try DataDirect Cloud Now

LIKE Escape Character Sequence for Wildcards

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

Syntax

{escape 'escape-character'}
where:
escape-character
is the character used to escape the wildcard character.

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 '*'}