Last updated 1 year ago
Returns the length of a string ().
LEN( string_expression )
LENGTH( <expression> ) LEN( <expression> )
string.length
Code:
SELECT LEN('Sample text') AS [LEN];
Output:
LEN| ---+ 11|
SELECT LEN('Sample text') AS LEN;
CREATE OR REPLACE FUNCTION get_len(str varchar) RETURNS float LANGUAGE JAVASCRIPT AS $$ return STR.length; $$; SELECT GET_LEN('Sample text') LEN;