>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.