I found this interesting question within SSP forums: Is it possible to return only the upper case of a given string. For a string say, 'My name Is John Cramps' I should get the output as 'MIJC' I am using SQL Server 2005. Visit forum http://sql-server-performance.com/Community/forums/t/27634.aspx post for more information & excellent code references.