Re: truncate column width

> Is it possible to truncate the width of certain columns when selecting
> records?

Certainly.

> something like:
> select * from mytable where width of this_column truncated to 30
> characters;

select substr('this_column', 1, 30) as this_column_trunc from mytable;

Greg