UPPER( )
Go Up to Statement and Function Reference (Language Reference Guide)
Converts a string to all uppercase. Available in gpre, DSQL, and isql.
UPPER (val)
| Argument | Description |
|---|---|
|
<val> |
A column, constant, host-language variable, expression, function, or UDF that evaluates to a character data type |
Description: UPPER() converts a specified string to all uppercase characters. If applied to character sets that have no case differentiation, UPPER() has no effect.
Examples: The following isql statement changes the name, BMatthews, to BMATTHEWS:
UPDATE EMPLOYEE
SET EMP_NAME = UPPER (BMatthews)
WHERE EMP_NAME = 'BMatthews';
The next isql statement creates a domain called PROJNO with a CHECK constraint that requires the value of the column to be all uppercase:
CREATE DOMAIN PROJNO
AS CHAR(5)
CHECK (VALUE = UPPER (VALUE));