T-SQL Tutorial

T-SQL UPPER String function


The T-SQL UPPER function is an string function and return a character expression after converting lowercase character data to uppercase.

UPPER Syntax:

UPPER ( string_expression );

UPPER Example:

DECLARE @mystring varchar(250);
SET @mystring = 'Convert transact sql UPPER Function';
SELECT UPPER(@mystring);
GO

Result
CONVERT TRANSACT SQL UPPER FUNCTION

See also: T-SQL Functions -> Substring | Patindex | Replace | Right | Rtrim | LOWER