truncate column width

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

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

best regards,
Hugo