A small view of a table

Hello,
I'd like to know if it's possible to do ,with a single statement, a select of the first 5 characters from all fields in a table.

I have tried this:

select substr(*,0,5) from mytable

and this:

select substr((select * from mytable),0,5) from mytable

but none worked. As a matter of fact I could easily create a view, but let's say I don't want to fill up my DB with so many views...is it possible
to do it that way?
Thanks
Francesco Received on Thu Nov 23 2000 - 04:24:33 CST