That sounds very reasonable. You may also want to consider adding a delimiter to your remarks so that they can be broken up at a later time.
For example: SELECT CONCAT(col1, chr(9), col2, chr(9), coln, etc) AS newCol m!ke -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, May 19, 2008 11:46 AM To: CF-Talk Subject: RE: How to combine multiple fields into one alias? Concerning the schema... I'm trying to merge the data from two different data providers' databases into one database. One provider has all remarks in a 'remarks' field and the second provider decided to divide their clients' remarks into four separate fields. (Don't know why they wanted to divide them up...) I'm going to merge the remarks in the four separate fields into one 'remarks' field in my db. Does that seem appropriate? Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305640 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
