Roger Pullen wrote:

>
> 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
>

You are using a beta release that is almost a year old. Since then we have had
0.9.5 and now RC1.

RC1 does have a couple of documented faults, but for the most part is reliable
and it is feature complete. It would be best to test things out with that
version or later ones as they become available. The version you have has no
new features over IB6.0 - just some bug-fixes (iirc).

Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further