Omnidex SQL Function: $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.

$LJ( < column_spec | 'string' > )

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'

$LJ(CUSTOMERS.COMPANY)

$RJ(CUSTOMERS.COMPANY)

Dynamic Information Systems Corporation

Dynamic Information Systems Corporation

Camco Systems

Camco Systems

ASK Computer Systems, Inc.

ASK Computer Systems, Inc.

…