Re: A small view of a table

Francesco Marchioni <Francesco.Marchioni_at_lastminutetour.com> schrieb in im Newsbeitrag: 8viqrt$dik$1_at_marte.lastminutetour.com...
> 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,
>[...]>

Hi Francesco,

your problem is not a question wether to use a view or not. You simply cannot use the '*' as placeholder for all fields in a function call. So you will have to list all fields explicitly:

select substr( a, 1, 5 ), substr( b, 1, 5 ), ... from mytable;

regards

--
Holger Kreft
====================
Verlion GmbH, Essen