Often people ask how to use InitCap function in SQL Server Initcap is used to capitalise each first letter of the word and keep rest as non-capital Pinal Dave has a post at http://blog.sqlauthority.com/2007/02/01/sql-server-udf-function-to-convert-text-string-to-title-case-proper-case Read More......(<a href="http://sqlserver-qa.net/blogs/extblog/archive/2010/07/19/initcap-function.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9335" width="1" height="1">