length function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

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 

length(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 length('Spark SQL ');
 10
> select length('床前明月光')
 5