Omnidex SQL Function: $RJ

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

The return data type is C STRING.

$RJ(string)

string 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