SQL Functions

$RJ

The $RJ function will right-justify a string by eliminating the trailing white space and inserting leading spaces as needed.

The return datatype is C STRING.

$RJ(string)

Required.

Required. The string that is to be right justified. This can be a string literal or other scalar_expression resulting in a string.

select $LJ(company), $RJ(company) from customers where company='systems'

Dynamic Information Systems Corporation
Dynamic Information Systems Corporation