String Functions MSSQL Tutorial

2>  select UPPER('ca')
3> GO
--
CA
(1 rows affected)