{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)}.