I do want to capitalize only the first letter of each word of each sentence from a SQL column. i.e: if the sentance is > 'I like movies' then I need the output > 'I Like Movies' Query: declare @a varchar(15) set @a = 'qWeRtY kEyBoArD' select @a as [Normal text], upper(@a) as [Uppercase text], lower(@a) as [Lowercase text], upper(left(@a,1)) + lower(substring(@a,2,len(@a))) as [Capitalize first letter only] Here I did upper, lower and Capitalize first letter only in my field(here I put just a random word). Here is my results: [![enter image description here][1]][1] Is there any possibilities to do that? Any possibilities to get results without using user defined function? I need the output `Qwerty Keyboard` [1]: https://i.sstatic.net/gnHG2.png