I want to capitalize only the first letter of each word of each sentence in a SQL column.
For example, if the sentence 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 column (here I put just a random word).
Here are my results:
Is there any possibilities to do that?
Any possibilities to get results without using user defined function?
I need the output Qwerty Keyboard