Thread: 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

> 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