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}