Dear all,

I have a little problem about SQL command. I have a table which has 3 fields. That 3 fields are contain the same article number. Can I use one SQL command to merge 3 separate field into one? Example shown as below:

Table A (1 record):

FieldA FieldB FieldC
----------- ------------ -------------
ABC DEF XYZ


After SQL command, Table B created (3 records).

FieldSQL
--------------
ABC
DEF
XYZ

Thanks a lot!!

Best Regards

Justy Chow