Lowercase—%LOWER
Use this function when you want CDC Replication to convert all uppercase characters in a string to lowercase during replication.
Syntax
%LOWER(value)Parameters
- value
- Specifies a character column, literal, or column function that returns a character string.
Result data type
Character-based. Returns NULL if value is NULL.
Examples
%LOWER(DEPARTMENT)Returns
the strings in the DEPARTMENT column in lowercase. For example, accounting
, marketing
,
and so on.
%LOWER(BrUcE JoNeS
)Returns
the string bruce jones
.
%LOWER(%SUBSTRING(BrUcE
JoNeS
,3,2))Returns the string uc
.
%LOWER(<<65>><<78>><<78>><<65>><<32>><<75>><<73>><<77>>
)Returns
the ASCII string anna kim
.