ucase function

  • Article
  • 04/07/2025

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns expr with all characters changed to uppercase according to the collation of expr. This function is a synonym for upper function.

Syntax

ucase(expr)

Arguments

  • expr: A STRING expression.

Returns

A STRING.

Examples

> SELECT ucase('SparkSql');
 SPARKSQL