One way might be to loaded the data into a temp table then concatenate the columns using a view and then do an insert into the real table.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of William Owens Posted At: Wednesday, August 11, 2004 7:13 AM Posted To: RB7-L Conversation: [RBG7-L] - NOTE FIELD Subject: [RBG7-L] - NOTE FIELD I am in the process of converting a dos application to windows. I have a table with (4) note fields. I am unloading to ASCII file to bring into new table. Is there anyway I can combine/merge all 4 note fields in one note field in new table Thanks Bill
