At 10:26 PM 29-11-01 +1100, I wrote:

>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

BUT - wait, wait wait -

this:

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

returned

SUB_5_5
=======
agici


and this:

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

returned

SUB_1_12
========
he magicians

Sorry, dear Claudio.

H.

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