Want output as follwos

Question

When I execute a query  select ('NILESH')  in sql server 2008 it gives the output as NILESH. But I want oupput as there should be only first letter capital rather than all the letters like I want o/p should be like  Nilesh  i.e. only first letter capital and others are small. How to write query for this.

Sanjeeb Lenka · Answer

HI try this DECLARE @name nvarchar(20)='NILESH' SELECT UPPER(LEFT(@name1))+LOWER(SUBSTRING(@name2LEN(@name)))

Shankar M · Answer

Hi Nilesh There is no Initcap function in Sqlserver as in Oracle. Instead we can write a custom function to achieve the same functionality. DECLARE @NAME VARCHAR(10) SET @NAME = 'NILESH' SELECT UPPER(SUBSTRING(@NAME11)) + LOWER(SUBSTRING(@NAME2LEN(@NAME)))

Iftikar Hussain · Answer

Hi Try like this select UPPER(LEFT('NILESH'1))+lower(SUBSTRING('NILESH'2len('NILESH'))) Regards Iftikar