Subject Re: [firebird-support] Re: cast blob sub_type 1 to varchar
Author Thomas Steinmaurer
> I use Firebird 2.1 (release candidate 2).
> I tried doing:
> select substr("TEXT",1,20) FROM "MOVI"
> But I get exactly same results.


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


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