 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / SQL Server Tools / February 2005Combining multiple columns into one column.
Dear all, I am having a problem on how to merge 3 columns into one column. I have a columns named [LastName], [FirstName] and [MiddleName], I want those columns to be as one and name it as [Name]. How will I do that? I already tried the trick like what I did in Access but it does'nt work in SQL. Please help me with this. Any suggestions will be much appreciated. Thanks in advance, Jir Try: alter table dbo.MyTable add MyComputedCOlumn as LastName + ', ' + FirstName + ' ' + MiddleName  SignatureTom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com . Dear all, I am having a problem on how to merge 3 columns into one column. I have a columns named [LastName], [FirstName] and [MiddleName], I want those columns to be as one and name it as [Name]. How will I do that? I already tried the trick like what I did in Access but it does'nt work in SQL. Please help me with this. Any suggestions will be much appreciated. Thanks in advance, Jir |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.