At 08:50 AM 23-11-01 +0100, you wrote:

>Helen,
>
> > Or maybe he meant it was stupid to return a result instead of raising an error...with which I agree.
>
>I see.
>While we're on the subject, I thought that substr was an internal
>function in Firebird RC1.
>Is that true? I can't seem to be able to use it (the parser rejects it).

No, it's not true. The internal function is SUBSTRING (see the release notes for syntax). the SUBSTR udf in ib_udf was fixed up, too.

HB

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________