Returns the left side of the String indicated in the @text parameter with the maximum number of characters specified in the @length parameter. If the @length parameter is greater or equal to the length of the String indicated in the @text parameter, the returned value is equal to @text.

Syntax

LEFT(@text, @length)

Parameters

•@text: Text to truncate

•@length: Maximum length of the value to return