maybe this will help? http://archives.postgresql.org/pgsql-sql/2000-06/msg00209.php
good luck ----- Original Message ----- From: "Dowdell, Jason G" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, March 06, 2003 3:03 PM Subject: Concatenate columns in SQL Server > Hi Guys, > > Just can't seem to remember how to concatenate columns in sqlserver. > I thought it was double pipes, "||" then I thought it was a plus sign "+". > Just can't seem to stick these query columns together. > > Thanks, > jason > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
