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..
then i will get the Output as a
only one space is der with 1st letter Capital by using MS SQL server.