Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Function Reference » Alphabetical list of functions

TRUNCNUM function [Numeric] Next Page

UCASE function [String]

Converts all characters in a string to uppercase. This function is identical the UPPER function.


UCASE( string-expression )


string-expression    The string to be converted to uppercase.


The UCASE function is similar to the UPPER function.

See also
Standards and compatibility

The following statement returns the value CHOCOLATE.

SELECT UCASE( 'ChocoLate' );