This should work. select 'myfield'=fieldOne +' '+ fieldTwo from TableName
You will need to do casting.. if you concatenate fields of different Data-Types. eg(cast fieldTwo as varchar(10)+...) Joe Eugene -------Original Message------- From: "Dowdell, Jason G" <[EMAIL PROTECTED]> Sent: 03/06/03 03:03 PM To: CF-Talk <[EMAIL PROTECTED]> 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
