At 02:04 PM 29/10/2003 +0100, you wrote:

>Hello I am a new user of firebird.
>I am a french guy.
>I would like to cut a string field. Like substr in oracle or mid in mysql
>and i don't find any documentation on string function.

select substring ('parapluie' from 2 for 4) from rdb$database;

(returns 'arap')

Documentation: release notes.

>And how can I spool or tee my isql session ?

SQL> OUTPUT '/data/scripts/myscript.sql'; (Linux)
SQL> OUTPUT 'D:\data\scripts\myscript.sql'; (Win32)
SQL> enter command;
SQL> enter another command;
SQL> ....;
SQL> OUTPUT; (brings output back to console window)

heLen