select UPPER('ca') : UPPER « String Functions « SQL Server / T-SQL Tutorial






2> select UPPER('ca')
3> GO

--
CA

(1 rows affected)








12.24.UPPER
12.24.1.UPPER Translates all characters within the string to upper case.
12.24.2.The LOWER() and UPPER() Functions
12.24.3.select UPPER('ca')
12.24.4.Changing Character Values to Upper