Length function: CHAR_LENGTH
This function computes the length of a string, returning an integer count of its characters. Trailing spaces are significant:
Integer CHAR_LENGTH( value Varchar )
Example
The following code:
SELECT CUSTOMERS.CUSTID, CUSTOMERS.CONTACT_FIRST
FROM "../Data Sources/MyDatabase/CUSTOMERS.SMA" CUSTOMERS
WHERE CHAR_LENGTH(CUSTOMERS.CONTACT_FIRST) > 5
returns:
102,Leslie
109,Michael
116,William

Additional Links:

Copyright Actuate Corporation 2012