Fold Function

Wed, 03/04/2009 - 20:02 |  hdanzl


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
‹ Substring FunctionupTrim Function ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Functions | String Value Functions

Powered by Drupal and Drupal Theme created with Artisteer.