Want o/p as follows

Question

When I execute a query " select ('NILESH AVHAD') " in sql server 2008 it gives the output as NILESH AVHAD'.
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 Avhad " i.e. only first letter capital and others are small. How to write function for this and how to call this function in sql server 2008? 

---