LIKENL

The LIKENL option controls whether the LIKE operator recognizes newline characters between lines of a text expression, when deciding whether a text value is like a text pattern. The LIKENL option applies to the text expressions on either side of the LIKE operator.

Data type

BOOLEAN

Syntax

LIKENL = {YES|NO}

Arguments

YES: Specifies that the LIKE operator recognizes newline characters between lines of a text expression. (Default)
NO: Specifies that the LIKE operator ignores newline characters between lines of a text expression. Newline characters are ignored in both of the expressions being compared.

Notes

Newline Characters

In the OLAP DML, the representation of a newline character is "\n".

Case Sensitivity

The setting of LIKECASE controls whether the LIKE operator is case sensitive.

Examples

Example 16-1 The Effect of LIKENL

The following statements show the use of the LIKENL option:

The statement
```
SHOW textvar
```
produces the following output.
```
Hello
world
```

The statements

LIKENL = YES
SHOW textvar LIKE '%low%'

produce the following output.

NO

The statement

SHOW '      Hello\nworld' LIKE '%\n%'

produces the following output.

YES

The statement
```
SHOW 'Hello\nworld' LIKE '%low%'
```
produces the following output.
```
NO
```

The statements

LIKENL = NO
SHOW textvar LIKE '%low%'

produce the following output.

YES

The statement
```
SHOW 'Hello\nworld' LIKE '%\n%' 
```
produces the following output.
```
YES
```
The statement
```
SHOW 'Hello\nworld' LIKE '%low%'
```
produces the following output.
```
YES
```