Functions

$LJ

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

The return data type is C STRING.

The return length is:

• the length of the string if the string is a C STRING column
• the length of the string +1 if the string is a CHAR column or a literal.

Syntax

$LJ(string)

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

Example

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

...

Top