Nóta
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as shíniú isteach nó eolairí a athrú.
Teastaíonn údarú chun rochtain a fháil ar an leathanach seo. Is féidir leat triail a bhaint as eolairí a athrú.
Applies to: 
Databricks SQL preview Databricks Runtime 11.3 LTS and above
Returns the character length of string data or number of bytes of binary data. This function is a synonym for character_length function and char_length function.
Syntax
len(expr)
Arguments
expr: A STRING or BINARY expression.
Returns
An INTEGER.
The length of string data includes the trailing spaces. The length of binary data includes trailing binary zeros.
Examples
> SELECT len('Spark SQL ');
10
> SELECT len('床前明月光');
5