I am getting the above error message on a trigger. I have stripped the trigger way way down to make it easier to diagnose the problem.

Here is the complete trigger

and here is the complete error:

Error: Compile Error: Method does not exist or incorrect signature: LEFT(String, Integer) at line 5 column 11

But I know that LEFT exists, and I know that 'Segal' is a string, and I know that 2 is an integer. So what am I missing?

Thanks.