TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
C# Corner
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
combining column names in sql server
Venkatesan Jayakantham
Apr 22, 2011
3.1
k
0
0
facebook
twitter
linkedIn
Reddit
WhatsApp
Email
Bookmark
combining column names in sql server
Consider am having column's as FirstName and another column as SecondName. If your result needs the output Name which is the combination of FirstName and SecondName or LastName.
Select FirstName +' '+ LastName as Name from YourTable
Cheers,
Venkatesan Prabu .J
Head - WWW.Kaashivinfotech.com
http://venkattechnicalblog.blogspot.com
combining column names in sql server
Next Recommended Reading
How to Sum the time in Varchar column in SQL Server