I have this query: SELECT IEA_ID, IEA_Name, Address + ' ' + Address2 + ' ' + City + ' ' + Phone AS IEAInfo FROM tblIEA ORDER BY IEA_Name
This query populates a select list with the IEA name, and when I select an item it binds the address info into a textarea. That all works fine. The problem I am having is that I want a line break in between the fields so it looks like a properly formatted address. How do I do this on the SQL end? Thanks, -- Bruce Sorge "I'm a mawg: half man, half dog. I'm my own best friend!" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2726 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
