Try \n. On 2/16/07, Bruce Sorge <[EMAIL PROTECTED]> wrote: > > 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:2727 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
