Yes, I understand what you mean. However this duplication is necessary as much of the work I do is for client supplied mailing lists. I work for a printer and many of the jobs that we print are variable data on our HP indigo, Canon, or ink jetted on the Busgro. All of the requirements for my job output to any of these printers have been to have that data contained in one field. This is not a problem if the clients files have been postal processed as I can export that info on the fly however some of the clients do not want their data postal processed. For the longest time I have been using excel to concatenate these fields and I really do not think databases should be pulled into excel.
Thanks Denise ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3493 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
