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}