Syntax

 

<fold> ::=

 

 

 

{ UPPER | LOWER } ( <character value expression> )

 

 

Notes

 

The UPPER function converts the source string to upper case.



 

The LOWER function converts the source string to lower case.



 

The data type of the result is the declared type of the argument.



 

If the argument is null, then the result is null.



 

 

Examples

 

Expression

 

Result

 

UPPER( 'Hello World' )

'HELLO WORLD'

LOWER( 'Hello World' )

'hello world'

 

 


 

Conformance

 

SQL:2003 standard

-

Core SQL