Previous Next JavaScript must be enabled to correctly display this content

## length function

The `length` function returns the length of a character string. The length function calculates the length using the UTF character set.

    returnvalue length(source)

    source ::= any*
    returnvalue ::= integer

Example: Find the length of the full name of the passenger whose ticket number is 1762350390409.

    SELECT fullname, length(fullname) AS fullname_length
    FROM BaggageInfo
    WHERE ticketNo=1762350390409

Output:

    {"fullname":"Fallon Clements","fullname_length":15}