Left

The Left() function returns the leftmost characters of a text value. The number of characters that is returned is set with the num_chars parameter.

If num_chars is larger than the number of characters in string, the complete text is returned. If num_chars is 0, an empty text is returned.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a text value containing the first num_chars characters of string, counted from the left.

Syntax

Left(string, num_chars)

Left("WEM Platform", 3) => "WEM"

Left("WEM", 10) => "WEM"

Parameters

Name	Type	Required	Description
string	Text	☑️	the text value you want to take the characters from
num_chars	Number	☑️	the number of characters to return, counted from the left