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.
Anonymous User
21-Jan-2015The best solution is to build a function. After some inspiration from the manipulations available online, I adapted it to your query;