Click here to Skip to main content
15,936,709 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi Frnds,
How to combine columns.I have FirstName,MiddleName,LastName in Registration Form.I Used this Query
select FirstName+' '+MiddleName+' '+LastName from RegistrationTable ...

Here Middle Name is Null Also.At that time Select Query showing null value if First and Last Name Present Also.At that time i used ISNULL(MiddleName,''),but at that time two spaces should not show in between FirstName and LastName.
Updated 24-Dec-12 3:14am

1 solution

SELECT RTRIM(FirstName + ' ' + ISNULL(MiddleName, '')) + ' ' + LastName FROM RegistrationTable
Share this answer
itsureshuk 24-Dec-12 9:38am    
OriginalGriff 24-Dec-12 9:55am    
You're welcome!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900