SQL Server UPPER() Function

Example

Convert the text to upper-case:

SELECT UPPER('SQL Tutorial is FUN!');

Definition and Usage

The UPPER() function converts a string to upper - case.

Note:

Syntax

Upper(

Parameter Values

Parameter

Description text

Technical Details

Works in:

More Examples

Example

Convert the text in "CustomerName" to upper - case:

SELECT UPPER(CustomerName) AS UppercaseCustomerName

FROM Customers;

Previous

Next