IBM Books

SQL Reference

UCASE



>>-UCASE--(--expression--)-------------------------------------><
 

The schema is SYSFUN.

Returns a string in which all the characters have been converted to upper case characters. All characters in the expression are monocased. That is a-z are translated to A-Z, and characters with diacritical marks are translated to their upper case if they exist. For example, in code page 850, é maps to É, but ÿ is not mapped since code page 850 does not include &Ye..

The argument can be CHAR or VARCHAR.

The result of the function is VARCHAR(4000). The result can be null; if the argument is null, the result is the null value.



[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]