Optional parameters that can be specified on the CASE statement define the conversion mode to be supported. You can specify one or more of the conversion mode parameters, but duplicates will be ignored.

NORMAL

Specifies basic casing, preferred mode for English text.

SPECIAL

Specifies normal casing and adds locale independent special casing.

LOCALE

Specifies special casing and adds locale-dependent special casing.