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.