Originally posted by vijays3
Originally posted by madamvegas
Converting an access db to sql and there is a function called StrConv which can convert the first letter of each word to uppercase. I checked to see if there was a corresponding function in sql and didn't find one. Is there an easy way to do this?
Very new to sql so trying to get into using the easist stuff I can so I can understand what I am doing whether than just copying someone's code.
check this out
declare @a varchar(20)
set @a = 'vijay'
select @a, upper(SUBSTRING(@a,1,1)) as firstc