Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links

 

SQL Reference

Functions

Syntax

Example

 

SQL Reference

Joins

Nested Queries

Set Operations

ON CURSOR | INSTANCE

WITH Options

Commands

Functions

 

UPPER

Converts a string to all upper case characters.

 

Syntax

UPPER(string)

string
Required. The character string that is to be upshifted.

 

Example

select
LOWER (contact) as low, UPPER(contact) as up
from customers where state = 'co'

low
-------------------------

up
-------------------------

john doe
jane johnson
jim smith

JOHN DOE
JANE JOHNSON
JIM SMITH

 

Top