I think Thomas suggested

SELECT SUBSTRING("TEXT" FROM 1 FOR 20) FROM "MOVI"

and not Substr...

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of danyschaer
Sent: 30. mai 2008 15:34
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: cast blob sub_type 1 to varchar

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