toUpper
toUpper
formats a string in all uppercase. toUpper
skips
rows containing null values.
Syntax
toUpper(
expression
)
Arguments
- expression
-
The expression must be a string. It can be the name of a field that uses the string data type, a literal value like
'12 Main Street'
, or a call to another function that outputs a string.
Return type
String
Example
The following example converts a string value into uppercase.
toUpper('Seattle Store #14')
The following value is returned.
SEATTLE STORE #14