Subject Re: [firebird-support] FB/IB equivalent of LEFT(string, count)
Author Helen Borrie
At 11:18 AM 13/12/2003 +0000, you wrote:
>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.

Standard SQL for what? The LEFT keyword in SQL is reserved. It's used in

>Can someone tell me the equivalent, please?

What does this function need to do?