Convert a string to upper-case.


   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.


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


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

Copyright © 1999-2024 SS64.com
Some rights reserved