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