I'm new to FB, and my old SQL knowledge seems to have deserted me here.

Using 'LEFT(field_name, count)' in a WHERE clause of a query gets me a
'TOKEN unknown' error.

I thought this was standard SQL, but evidently FireBird has other ideas.

Can someone tell me the equivalent, please?

Cheers
Terry Riley