Changing Fiirst Letter to capital

Hello there
Is there a simple way to change first letter on string to capital letter?[Reposted, as posts from outside msnews.microsoft.com does not seem to make
it in.]
Roy Goldhammer (roy@.hotmail.com) writes:
> Is there a simple way to change first letter on string to capital letter?
SELECT upper(substring(strcol, 1, 1)) + substring(strcol, 2, len(strcol))
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.seBooks Online for SQL
Server 2005
athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000
athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx