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

does not work for me - is this all version specific?

I have GDS32.dll V 0.9.4.41 dated 29 Dec 2000

Roger

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: 29 November 2001 11:37
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Substring


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