SELECT one + two AS onetwo FROM table -OR-
SELECT one + ' ' + two AS onetwo FROM table -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Phillip B Sent: Tuesday, February 18, 2003 5:41 PM To: SQL Subject: Combine fields Is there an easy way in SQL 2000 to combine multiple columns in to one column? Something like this select merg(one, two, three) as onetwothree from table Thanks Phillip B. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
