LN or UPPER

UCASE or UPPER returns a string in which all alphabetic characters in the input character expression have been converted to uppercase.

UPPER and UCASE follow the database locale.

Syntax

UCASE or UPPER ( CharacterExpression ) 

CharacterExpression

A  LONG VARCHAR data type, or any built-in type that is implicitly converted to a string (but not a bit expression).

Results

The data type of the result is as follows:

  • If the CharacterExpression evaluates to NULL, this function returns NULL.
  • If the CharacterExpression is of type  CHAR.
  • If the CharacterExpression is of type  LONG VARCHAR.
  • Otherwise, the return type is  VARCHAR.

The length and maximum length of the returned value are the same as the length and maximum length of the parameter.

Example

To return the names of players, use the following clause:

splice> SELECT UCASE(DisplayName)
   FROM Players
   WHERE ID < 11;
1
------------------------
BUDDY PAINTER
BILL BOPPER
JOHN PURSER
BOB CRANKER 
MITCH DUFFER 
NORMAN AIKMAN 
ALEX PARAMOUR 
HARRY PENNELLO
GREG BROWN
JASON MINMAN

10 rows selected

See Also