Wow, that took a long time. Nevermind, I did find my answer. Ltrim(Rtrim(shipToAddress1 + ' ' + coalesce(shipToAddress2, '')))
-----Original Message----- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Friday, April 01, 2005 11:11 AM To: CF-Talk Subject: SOT: SQL Concatenation Sorry for this, but I've lost my mind this morning. Please is someone could tell me how to do this I would be forever grateful. SELECT billToAddress1 + ' ' + billToAddress2 AS billToAddress FROM tbl_orderHeader_archive If the billToAddress2 column is null or empty this select statement returns empty. Can someone please tell me how to have it return the billToAddress1 and billToAddress2 concatenated even if the billToAddress2 is empty or null? Thanks Bryan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201200 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54