SQL Functions

$LJ

The $LJ function will left-justify a string by eliminating the leading white space.

The return datatype is C STRING.

$LJ(string)

Required.

Required. The string that is to be left. 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