UPPER Case in MS SQL

 By using the UPPER(), you can retrieve your character data with caps.

SELECT RTRIM(LTRIM(UPPER(DSG_NAME))) FROM HS_HR_DESIGNATION