Navigation:  »No topics above this level«

LENGTH()

Advantage Concepts

Return to chapter overview

Scalar function that returns the length of a character string excluding trailing spaces.

Supported in SQL:

Yes

Supported in Navigational:

Yes

Syntax

LENGTH(<cString>) à nCount

Parameters

<cString>

The character string to count.

Return Values

LENGTH() returns the length of a character string as an integer numeric value.

Remarks

LENGTH() returns the length of a character string excluding trailing spaces.

Note Binary and image fields are not supported by this function. Memo fields are supported by the SQL version of the scalar.

See Also

LTRIM()

RTRIM()

LEN()