hello,
you have to use these sql keywords to get the answer .
Upper
Substring
lower
example
declare @name varchar(200)
set @name='AniMesh'
select Upper(Substring(@name,1,1))+lower(SUBSTRING(@name,2,len(@name)))
here the first letter will be Capital and rest will be small .
and output will be
'Animesh'
Thanks
Animesh