STRLEFT

Returns the leftmost N characters of a string. Alias for LEFT.

Analyze Syntax

func.strleft(<str>, <len>)

Analyze Examples

func.strleft('StarRocks', 4)

┌────────┐
 'Star'  
└────────┘

SQL Syntax

STRLEFT(<str>, <len>)

SQL Examples

SELECT STRLEFT('StarRocks', 4);

┌──────┐
 Star  
└──────┘