LEN

Applies to

• SQL Server

• Azure Synapse Analytics

Description

Returns the length of a string (LEN in Transact-SQL).

Sample Source Pattern

Syntax

SQL Server

LEN( string_expression )

Snowflake SQL

Snowflake SQL complete documentation

LENGTH( <expression> )
LEN( <expression> )

JavaScript

JavaScript SQL complete documentation

string.length

Examples

SQL Server

Code:

IN -> SQLServer_01.sql

SELECT LEN('Sample text') AS [LEN];

Output:

LEN|
---+
 11|

Snowflake SQL

Code:

OUT -> SQLServer_01.sql

SELECT LEN('Sample text') AS LEN;

Output:

LEN|
---+
 11|

JavaScript

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|

Known Issues

No issues were found.

Related EWIs

No related EWIs.