UPPER( )
From InterBase
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));