`uppercase(X)`

Returns a given string converted to all uppercase.

Syntax

uppercase(X)

Input

Argument	Type	Description
`X`	text	A scalar value or the name of a column

Return Value

Returns a text value corresponding to the input string in all uppercase.

If X is N/A, the result is N/A.

Sample Usage


`value`	`uppercase(value)`
'BaNana'	'BANANA'

Example

In the "ZIP to MSA Mapping" table (pub.geo.msa), you can convert the names of the counties to uppercase. To do this, create a computed column and apply the uppercase(X) function to the county column:

<base table="pub.geo.msa"/>
<willbe name="example" value="uppercase(county)"/>

The values in the county column are converted to uppercase.

For example, the result for the county named "Suffolk" would be "SUFFOLK". The result for the county named "Sabana Grande" would be "SABANA GRANDE".

Additional Information

This function does not work with Unicode (UTF-8) strings.
For a Unicode-compliant alternative, consider strupcase(X).