Hi again,

>>
>> Any ideas how I can shorten the result inside a view?

> So, have you tried to create a view and see if in both IBExpert and isql
> the resulting field is reported as VARCHAR(32765)?

I'd expect that the following statement should work.

But it doesn't:

select LPAD('ABC',10,'*'), RPAD('ABC',10,'*')
FROM RDB$DATABASE;


Result:
Dynamic SQL Error
SQL error code = -204
Implementation limit exceeded
block size exceeds implementation restriction

(Tested with Firebird 2.1.1, 2.1.2 RC2 and 2.1.2 latest snapshot)





--
Björn Reimer - RRZE