Jason, I use a plus sign - but remember the data types have to match. So I can do:
SELECT fname + ' ' + lname AS FullName (both being character), but I cannot do: SELECT lastname + '-' + emp_id AS Employee_id .....assuming that emp_id is an INT.... To make it work I'd have to use "CAST( )" or CONVERT( ) SELECT lastname + '-' + CAST(emp_id AS varchar(10)) AS Employee_id hope this helps you... -----Original Message----- From: Dowdell, Jason G [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 2:03 PM To: CF-Talk 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
