Hi,

I need to copy data from tables.

I'm trying with this:

select cod_art as itemid, ;
alltrim(des_art) + " " + alltrim(des_art1) as itemname, ;
tipo_articolo as itemgroupid, ;
cod_umisu as bomunitid;
from articoli;
into cursor cur_articoli

des_art is C(50)
des_art1 is C(50)

on the target table, itemname is C(100)
on the cursor, itemname is C(19)... the lenght of the first des_art..
Can I force the lenght of the column?

thanks
Fabio