capitalise the first letter of each word in a string

Question

 

I want to update table

What’s the best way to capitalise the first letter of each word in a string in SQL Server ...Using Query

 

Table Name :- MasterCategory

Column Name:- Category