Text & patterns
Scalar
upper()
Converts string to upper case.
Arguments & returns
upper(string)
Scalar
| Overload link | string |
Returns |
|---|---|---|
| #01 | VARCHAR |
VARCHAR |
Example
Haybarn WASM 1.5.5-rc3 · In your browser
Engine example · Run to view results.
In other engines
Used in larger rewrites 1
These examples use upper as one part of a larger SQL translation.
Snowflaketry_to_boolean()
TRY_TO_BOOLEAN('true')
In DuckDBCASE WHEN UPPER(CAST('true' AS TEXT)) = 'ON' THEN TRUE WHEN UPPER(CAST('true' AS TEXT)) = 'OFF' THEN FALSE ELSE TRY_CAST('true' AS BOOLEAN) END