!!!LTRIM and RTRIM
!Functionality:
This Oracle function will remove characters on the left or right (usually spaces)

!Parameters:    
|STRING |The source, or original, string
|CHAR   |(optional)  The last character(s) you want to be retained in the string.  Default is blank

!Returns: 
Text

!Errors:  
None

!Operations: 
If start position is 0, then start position is taken as 1

If start position is negative, then substr starts at the end and counts backwards

If length is negative, then NULL is returned
 
!Example:

{{rtrim(~)}} will remove all trailing blanks from the passed string
{{rtrim(ltrim(~))}} will remove all leading and trailing blanks from the passed string
{{ltrim(~,’0123456789’)}} will remove all leading numbers (up to the first non numeric from the passed string  (e.g.  57412AB33 would become AB33)


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