forum

Home / DeveloperSection / Forums / How to remove spacing between 2 words

How to remove spacing between 2 words

Anonymous User 1960 21-Jan-2015

I am having one column containing both the first-name and second-name. Now i want to make a function which remove all the spaces between first name and last name and make 1st letter as as capital follow with the small letter.

For example if user type..

muKesH          AmBanI

then i will get the Output as a

Mukesh Ambani

only one space is der with 1st letter Capital by using MS SQL server.


Updated on 21-Jan-2015
I am a content writter !

Can you answer this question?


Answer

1 Answers

Liked By