Ucase

Convert a string to upper-case.

Syntax
      Ucase(string)

Key
   string    A string or string expression.

The Ucase() function can be used in VBA or in an SQL query.

Ucase() will return a Variant, you can also use Ucase$() to return a String.
You should use Ucase() if there is any chance of a Null value, since assigning Null to a String will raise an error.

Examples

Dim strDemo as String
strDemo = Ucase("12 Acacia Gardens")
Msgbox strDemo
Returns "12 ACACIA GARDENS "

“Those who cannot hear an angry shout may strain to hear a whisper” ~ Leonard Nimoy

Related:

Nz - Detect a NULL value or Zero Length string.
LCase - Convert a string to lower-case.
Swap Case - Reverse CAPS lock