Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Function Expressions
Case-Conversion FunctionsThe case-conversion functions perform lettercase conversion on alphabetic characters. In the default locale, only the ASCII characters in the ranges A - Z and a - z can be modified by these functions, which enable you to perform case-insensitive searches in your queries and to specify the format of the output.
UPPER Function

UPPER Function

The UPPER function accepts an expression argument and returns a character string in which every lowercase alphabetical character in the expression is replaced by a corresponding uppercase alphabetic character.

The following example uses the UPPER function to perform a case-insensitive search on the lname column for all employees with the last name of Curran:

SELECT title, INITCAP(fname), INITCAP(lname) FROM employees
   WHERE UPPER (lname) = "CURRAN"

Because the INITCAP function is specified in the projection list, the database server returns the results in a mixed-case format. For example, the output of one matching row might read: accountant James Curran.