Thank you Thomas;

I use Firebird 2.1 (release candidate 2).
I tried doing:

select substr("TEXT",1,20) FROM "MOVI"

But I get exactly same results.

Dany

>
> --
> Best Regards,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database, MS SQL Server and
> NexusDB V2
> Upscene Productions
> http://www.upscene.com
>