I have several columns called for simplicity A, B, C, D and E that are all in the same table. I need to join A, B, and C into one column called FullName and still have D and E in separate columns. I can get A, B, and C into a new column with the following select statement: Select(LastName + ', ' + FirstName + ' ' + MiddleName) As FullName. However, I can't figure out how to get D and E into the select statement to have them put in there own columns. Any idea?
Also, the resulting dataset needs to be in ascending order by the newly created column FullName.