I have no idea how you could get 3 records but is this what you are looking for --

select FieldA + FieldB + FieldC as MyNewField from TableA where...


>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