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

Try:

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

--
Milan Babuskov
http://www.flamerobin.org