4.9.2.43 LENGTH function (ODBC compatible)

Syntax

LENGTH ( char_expression )

Description

The scalar function LENGTH returns the string length of the value of the given character expression.

Example

SELECT name 'LONG NAME'
     FROM  customer
     WHERE LENGTH (name) > 5 ;

Notes

• The argument to the function must be of type CHARACTER or VARCHAR.
• The result is of type INTEGER.
• If the argument expression evaluates to null, the result is null.