![]() Previous |
![]() Next |
The LIKECASE option controls whether the LIKE operator is case sensitive.
Tip: The LIKENL option controls whether the LIKE operator recognizes newline characters. |
Data Type
BOOLEAN
Syntax
LIKECASE = {YES|NO}
Parameters
(Default) Specifies that the LIKE operator is case sensitive.
Specifies that the LIKE operator is not case sensitive.
Examples
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 statement is
NO
The SHOW statement
SHOW 'ORACLE' LIKE '%orc%'
produces the following output.
NO
The statements
LIKECASE = NO SHOW 'ORACLE' like 'orc%'
produce the following output.
YES