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 1 - 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}