LEN
Description
Returns the length of a string (LEN in Transact-SQL).
Sample Source Pattern
Syntax
LEN( string_expression )Snowflake SQL complete documentation
LENGTH( <expression> )
LEN( <expression> )JavaScript SQL complete documentation
string.lengthExamples
Code:
SELECT LEN('Sample text') AS [LEN];Output:
LEN|
---+
11|Code:
SELECT LEN('Sample text') AS LEN;Output:
LEN|
---+
11|Code:
CREATE OR REPLACE FUNCTION get_len(str varchar)
RETURNS float
LANGUAGE JAVASCRIPT
AS
$$
return STR.length;
$$;
SELECT GET_LEN('Sample text') LEN;Output:
LEN|
---+
11|Last updated