Omnidex SQL Function: $RPAD

Description

Pad the string on the right with spaces or the named character. If the string is already padded, as happens with a CHARACTER datatype, the string must first be trimmed using the TRIM function.

This function returns a STRING datatype.

Syntax

$RPAD( character_expression, num_characters [, pad_character] )
character_expression

Required. Any expression that returns a character-class datatype. Examples of expressions are columns, concatenations of columns, literal strings and functions that return a character datatype.

num_characters

Required. The number of characters to be returned from the function, with the right-most characters padded with spaces or the named character.

pad_character

Optional. The character to be used to pad the string. If this parameter is omitted, then a space is used as the pad character.

Examples

Example: Column

In this example, the name must first be trimmed since it is already padded with spaces.

> select $rpad(trim(name), 40, '.') nme from individuals;

NME
----------------------------------------
MS. MARY LEWIS..........................
MRS. ALICE R TOLLIVER...................
MR. SIDNEY K TOLLIVER...................
MRS. JENNIFER J HOPKINS.................
MR. CHARLIE HOPKINS.....................
MS. KIMBERLY BLUE.......................
KATHLEEN TUCKER.........................

Additional Resources

See also:

 
Back to top
dev/sql/functions/rpad.txt ยท Last modified: 2016/06/28 22:38 (external edit)
 
 
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0