Concatenate

D

David

Hello,
I have a table of 20 columns of text. I would like to
concatenate the values from these 20 columns into
one "sum" column. I had been exporting the file to Excel
and using the Excel "&" function. However the table is now
500k rows and of course that makes exporting to Excel
impractical.

Any suggestions for this non-programmer ?

TIA
 
D

Duane Hookom

Why not create a column in a query like:
BigField:FieldA & FieldB & FieldC & ....
 
Top