Click here to Skip to main content
15,920,513 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.
Posted
Updated 24-Dec-12 3:14am
v2

1 solution

Try:
SQL
SELECT RTRIM(FirstName + ' ' + ISNULL(MiddleName, '')) + ' ' + LastName FROM RegistrationTable
 
Share this answer
 
Comments
itsureshuk 24-Dec-12 9:38am    
thnks
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