> Use substring to cut the "excess" and then cast it to the desired size,
> something like this:

> select cast(Substring(LPAD('ABC',10,'*') from 1 for 10) as
> varchar(10)), cast(Substring(LPAD('ABC',10,'*') from 1 for 10) as varchar(10))
> FROM RDB$DATABASE;

Thanks, that did it.





--
Björn Reimer - RRZE