!!!LPAD and RPAD
!Functionality:
This Oracle function will justify and fill a passed character string to a specified size with an optionally sepecifed character

!Parameters:    
|STRING  | The source, or original, string
|LENGTH  | The length you want the returned value to be
|CHAR    | (optional)  The character(s) you want any extra spaces to be filled with.  If not provided, this will be a 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:

{{lpad(~,12)}} will return, the passed string, right justified and padded on the left with blanks to a length of 12 characters.

{{lpad(~,12,'0')}} will return, the passed string, right justified and padded on the left with zeroes to a length of 12 characters.

{{rpad(~,8,'*')}} will return, the passed string, left  justified and padded on the right with asterisks to a length of 8 characters.


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