> I use Firebird 2.1 (release candidate 2).
> I tried doing:
>
> select substr("TEXT",1,20) FROM "MOVI"
>
> But I get exactly same results.

Does

select substring("TEXT" from 1 for 20) from "MOVI"


work?


Btw, don't use a RC, if there is a production ready version available. ;-)




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