LENGTH
Returns the length of a given string.
Syntax
Arguments
STRING
STRING
Type: string
A sequence of characters.
Returns
Type: bigint
The length of STRING
in characters.
Examples
STRING | Output |
---|---|
1 | 1 |
abcdefg | 7 |
12345 | 5 |
|
|
| 0 |
-=^%$ | 5 |
Transformation job example
SQL
Query result
customer_firstname | name_length |
---|---|
Karen | 5 |
Evelyn | 6 |
Carol | 5 |
Last updated