Want output as follwos

Sep 17 2013 7:12 AM

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.

Answers (3)

Non clustered indexes

Want o/p as follows