Administer > Database Administration > Data persistence > Queries > Cross-table join query improvements > lng()

lng()

The lng() function determines the length of a value specified by the parameter.

Example of the lng Function Translation
Service Manager function Translated SQL equivalent: 
select ps.number, ps.title from probsummary ps where lng(ps.openen.by)=6
 
select t01.”NUMBER”, t01.”TITLE” from PROBSUMMARYM1 t01 where LENGTH(t01.”OPENED_BY”) = 6

The parameter can only be a field name or an expression that can be evaluated beforehand; It cannot be an expression that cannot be evaluated before translation into SQL:

The following cases are valid:
lng ( ps.category )    //In this example, “category” is a field from file “probsummary”
lng ( $L.var )    //In this example, $L.var is a local variable defined beforehand.
The following cases are invalid:
lng ( ps.title + ps.brief )
lng ( ps.title + $L.var )

Send Help Center feedback