UPPER( )

From InterBase
Jump to: navigation, search

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));

See Also