The function UPPER-It converts a string into the UPPER case.
Syntax.
UPPER (Column_name)
The LOWER function-It converts string into lower case.
Syntax:
LOWER (Column_name)
The INITCAP function-It converts the first letter into CAPITAL.
Syntax:
INITCAP(Column_name)
The trim functions. Read examples online here.
The LTRIM. It looks for the left side of the String.
Syntax:
LTRIM(column_name,’*’);
The RTRIM. It looks for right side of the string.
Syntax:
RTRIM(column_name,’*’);
Sources
