Hi All;

Yes, I am trying noy your

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

and it works but ... the truth is that I was trying to use a standard
sql to make my sentences compatible with Firebird & Oracle & PostgreSQL.

select cast("TEXT" as varchar(20)) from "MOVI" ... works in Oracle and
PostgreSQL.

SELECT SUBSTRING("TEXT" FROM 1 FOR 20) FROM "MOVI" works only in
Firebird, I guess.

Dany