LIKECASE

The LIKECASE option controls whether the LIKE operator is case sensitive.

Data type

BOOLEAN

Syntax

LIKECASE = {YES|NO}

Arguments

Notes

Newline Characters

The LIKENL option controls whether the LIKE operator recognizes newline characters.

Examples

Example 15-40 The Effect of LIKECASE

The following statements show the use of the LIKECASE option.

LIKECASE = YES
SHOW 'oracle' LIKE 'Oracle%'

The output of this SHOW command is

NO

The SHOW command

SHOW 'ORACLE' LIKE '%orc%'

produces the following output.

NO

The statements

LIKECASE = NO
SHOW 'ORACLE' like 'orc%'

produce the following output.

YES