QuickLinks Statements Functions OdxSQL

Omnidex SQL Function: $RJ

Description

Right-justify the character expression.

This function returns a STRING datatype.

Syntax

$RJ( character_expression )
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.

Examples

Example: Column

> select $rj(name) 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: