As most of the databases support the case conversion functions, Informatica also provides the capability of converting a string from one case to the other.

The syntax of the case conversion functions are shown below:

Code:
UPPER(string)
LOWER(string)
INITCAP(string)
The upper function converts a string to capital letters. Example:

Code:
upper('inforMAticA') returns INFORMATICA
The lower function converts a give string to the lower case letters. Example:

Code:
lower('Power CEnter') returns power center
The Initcap function converts the first character in each word to the upper case and remaining characters to lower case letters. Example:

Code:
initcap('etl TOOL') returns Etl Tool