I had a bug to fix today which was to convert some country names which were in upper case into proper case - i.e. to convert AUSTRALIA to be Australia. SQL Server only provides functions to convert to upper case and lower case but I figured someone would have written a function already. A quick search in google and I came across Vyas's code library amongst which was a link to a function called ProperCase. The header says it is tested against SQL Server 2000, but I can confirm it has done the trick for me in SQL Server 2005 as well.