| Subject | Re: [firebird-support] FB/IB equivalent of LEFT(string, count) |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-12-13T12:17:08Z |
At 11:18 AM 13/12/2003 +0000, you wrote:
LEFT OUTER JOIN.
/heLen
>I'm new to FB, and my old SQL knowledge seems to have deserted me here.Standard SQL for what? The LEFT keyword in SQL is reserved. It's used in
>
>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.
LEFT OUTER JOIN.
>Can someone tell me the equivalent, please?What does this function need to do?
/heLen