At 12:26 PM 29-11-01 +0100, Svein wrote:

> >Trying SUBSTRING on Firebird thus
> >P1 = SUBSTRING("ABCDEF" FROM 1 FOR 4);
> >will not even compile. P1 is a previously
> >defined variable (It is part of a SP.)
>
>But what is "ABCDEF"? If it is a string, I think you should have used
>single quotes - double quotes may leave FB believing it is a field name
>(though I'm far from certain this is the case).

Svein is right.

this:

select substring('The magicians are assembled here' FROM 1 FOR 6) from rdb$database

returned

SUBSTRING
=========
The ma

select substring('The magicians are assembled here' FROM 5 FOR 5) from rdb$database

returned

SUBSTRING
=========
magic


cheers,
H.

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