SELECT [Whims_and_Fancies] from [my_SQL_Server_Knowledge];
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.
About satya
SQL Server MVP.
SQL Master, Speaker & SQL Server helper.
16+ years of IT experience in which as a Sr. DBA and Technical Design Lead in sectors of Banking, Stock markets & Investment Banking, Manufacturing & consulting.
Out of professional activities :
Moderator - SQL Server Performance forums & MSDN forums in addition to my homepage above.
Active member of most of the SQL Server community forums.