LEFT

{fn LEFT(expr,n)}

Returns the first n characters of expr.

The LEFT and RIGHT built-in functions are also SQL keywords. You must enclose them in {fn <LEFT | RIGHT>(parameters)}.