LENGTH( ) function

Returns the length of a string.

Syntax

LENGTH(string)

Parameters

string

Character. The value to find the length of.

Output

Numeric.

Remarks

This function counts the number of characters in a string, including any spaces, and returns the number. ACL counts any trailing spaces in the length. If you do not want trailing blanks to be counted, use the TRIM( ) function to remove the trailing blanks. If you do not use the TRIM( ) function when using the LENGTH( ) function, the length value specified for the field, which is the maximum length of the field, will be returned for each row.

Examples

Example Return value

LENGTH(“ACL Services”)

12

LENGTH(Description)

Returns the Length value specified for the Description field in the table layout.

LENGTH(TRIM(Description))

Returns the length of each individual value in the Description column.

Related reference
TRIM( ) function


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback