TRIM#
Functionality:#
This Oracle function will remove characters on the left or right or both (usually spaces)Parameters: #
LOCATION | (optional) Where in the string you want the characters removed. Can be LEADING, TRAILING or BOTH. If not specified, BOTH is used |
REMOVESTR | (optional) The characters that you want removed. If not specified then white space will be removed |
STRING | The target string to be worked on. |
Returns: #
TextErrors: #
NoneOperations: #
If LOCATION is provided the keyword FROM must also be included.Example:#
TRIM(LEADING '0'FROM ~) will remove all leading zeroes from the passed string