Hi to All,

could SomeOne resolve this problem?

When I execute this command:
Code:
CREATE TEMP TABLE T2
AS SELECT item, number, price
FROM T1
I obtain that the lenght of the field "item" my be of 100 charachters if in T2 exists an item of 100 characters.

Instead I'd Like to obtain the lenght of the field "item" is of 40 characters.

Is it possible?
If yes, how is it possible?

Tanks in advance
Gianni Pinna.