Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > .NET General

Vista - Combining Columns

Reply
 
Old 09-10-2008   #1 (permalink)
BobbyPS2805


 
 

Combining Columns

How can you combine the information in two columns to one?

Column A is first name
Column B is last name

I need there to be one column with both first and last name.
(There is roughly 300K rows)

My System SpecsSystem Spec
Old 09-10-2008   #2 (permalink)


Vista Business x64
 
 

Re: Combining Columns

SELECT A + ' ' + B as fullname
FROM mytablename

This returns the data to your app with the two fields combined with a space separator. Last name first is:

SELECT B + ', ' + A as fullname
FROM mytablename
My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
Help with combining command. PowerShell
Combining WMI Results possible? PowerShell
Combining Drives Vista General
How to Disable ''Write Combining''? Graphic cards
Disable Write Combining? Vista General


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46