Uppercase—%UPPER
Use this function when you want CDC Replication to convert all lowercase characters in a string to uppercase during replication.
Syntax
%UPPER(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
%UPPER(DEPARTMENT)Returns
the strings in the DEPARTMENT column in uppercase. For example, ACCOUNTING
, MARKETING
,
and so on.
%UPPER(AnDrEa MoSs
)Returns
the string ANDREA MOSS
.
%UPPER([emp ny]
)Returns
the string [EMP NY]
.
%UPPER(%SUBSTRING(AnDrEa
MoSs
,3,2))Returns the string DR
.
%UPPER(<<97>><<110>><<110>><<97>><<32>><<75>><<73>><<77>>
)Returns
the ASCII string ANNA KIM
.