!!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: 
Text

!Errors:  
None

!Operations: 
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


----
![Notes|Edit:Internal.TRIM] 	
[{InsertPage page='Internal.TRIM' default='Click to create a new notes page'}]