Character Functions
LOWER :Converts the character strings to lower case characters
syntax :LOWER(string)
UPPER: Converts the character strings to upper case characters
syntax :UPPER(string)
INITCAP : Converts the character strings to first character as upper case and rest as lower case
syntax :INITCAP(string)
CONCAT :Joints two values together
syntax :CONCAT(string1, string2)
SUBSTR : Extract a string of determined length from string
syntax :SUBSTR (char, position [, substring_length ])
LENGTH : Shows the length of a string
syntax :LENGTH(string)
INSTR : Finds the numeric position of a named character
syntax :INSTR (string , substring [, position [, occurrence]])
LPAD: Returns an expression left-padded to the length of n characters with a character
expression
syntax: LPAD (text-exp , length [, pad-exp])
RPAD: Returns an expression right-padded to the length of n characters with a character
expression
syntax: RPAD (text-exp , length [, pad-exp])
 |
| INITCAP |
 |
| INSTR |
 |
| LENGTH |
 |
| LOWER |
 |
| LPAD |
 |
| RPAD |
 |
| SUBSTR |
 |
| UPPER |
