upper
Differences
This shows you the differences between two versions of the page.
| — |
upper [2015/09/23 20:27] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | ====== UPPER Function - PL/HQL Reference====== | ||
| + | |||
| + | UPPER function converts a string expression to upper case. | ||
| + | |||
| + | **Syntax**: | ||
| + | |||
| + | <code language="sql"> | ||
| + | UPPER(expression); | ||
| + | </code> | ||
| + | |||
| + | **Return Data Type:** | ||
| + | |||
| + | STRING | ||
| + | |||
| + | **Example:** | ||
| + | |||
| + | Convert a string to upper case: | ||
| + | |||
| + | <code language="sql"> | ||
| + | UPPER('abc'); | ||
| + | --- | ||
| + | ABC | ||
| + | </code> | ||
| + | |||
| + | **Compatibility**: Oracle, Microsoft SQL Server, IBM DB2, Teradata, PostgreSQL, MySQL and Netezza | ||
| + | |||
| + | **Version**: PL/HQL 0.03 | ||
Page Tools
