Create a function that convert the first letter of all words in capitalized form?
Create a function that convert the first letter of all words in capitalized form?
Ask by Ashutosh Kumar Verma
Updated 09 Nov 2021
SQL Function to convert all Words into Capitalized:
Sometimes we have need to convert all the first letter of all words into capitalized from, hence I have create a SQL function to convert all the words into capitalized from.
Following function is converts first letter of all the word in capitalized, or we can say that it word like a capitalized function that convert the first letter of words into capital form.
Now, execute the above function with values.
select [dbo].[fn_CapitalFormat]('my self Mr. india') AS Capitalize;