Microsoft SQL Server Upper


Example

Returns a character expression (varchar or nvarchar) after converting all lowercase characters to uppercase.

Parameters:

  1. Character expression. Any expression of character or binary data that can be implicitly converted to varchar.
SELECT UPPER('This IS my STRING') -- Returns 'THIS IS MY STRING'

DECLARE @String nchar(17) = N'This IS my STRING';
SELECT UPPER(@String) -- Returns 'THIS IS MY STRING'