> 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.
In SQL Server, or more specifically Transact-SQL, the plus sign is the string concatenation operator. However, you have to make sure that both of your columns are strings for this to work, so you may have to use CONVERT or CAST. You may also have issues if one of the columns contains a null. For information like this, I'd strongly recommend that you get a local copy of SQL Server Books Online. You can install it from the SQL Server installation media, I think, or download it from the Microsoft site. It's a Windows Help file chock-full of SQL Server goodness. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
