LEN

✅ Azure Stream Analytics ✅ Fabric Eventstream

Returns the number of characters of the specified string expression, excluding trailing blanks.

Syntax

LEN ( string_expression )  
  

Arguments

string_expression

Is the string expression to be evaluated. string_expression can be a constant or column of type nvarchar(max)

Return Types

bigint

Examples

SELECT TollId, EntryTime, LicensePlate, LEN (LicensePlate) AS Len_License  
FROM Input TIMESTAMP BY EntryTime  
WHERE Toll > 5