hi,

types is characters for NEWQ and all data

NEWQ
-----
rec#1 q
rec# 2 qa
.
.
.
rec#n  q50aaaaaaa&& not more 10 characters

thanks
>>hi all,
>>how i can convert all fileds from my table to data as one field at new table
>>ex..
>>if my fields name as q,qa,q1a,qa22....etc convert at new table as
>> myfield name as (NEWQ) have data as q,qa,q1a,qa22....etc
>>thank you.
>
>What types are q,qa,q1a,qa22.... and what type is NEWQ?
>How you want to store the values?
>If the q,qa,q1a,qa22.... are numeric didn you want just to replace NEWQ with their addition:
>2+3+5+7 -> NEWQ = 17
>or want NEWQ= "2 3 5 7"
>Keep in mind that you can't have a string field longer then 254 bytes.