How to Convert the Case of a String

MS-SQL Server provides the following case related functions as seen in the following SQL example:

select lower('jaMES') as lower , upper('jaMES') as upper;
lower upper
james JAMES

IN THIS PAGE