Entering content frame

UPPER/LOWER(x) Locate the document in its SAP Library structure

UPPER(x) and LOWER(x) are string functions that convert a character string x (string specification) to uppercase/lowercase letters. Only expressions that have an alphanumeric value as a result are allowed as a string specification (string spec).

 

Result of the UPPER(x) or LOWER(x) Function

x is a NULL value

NULL value

Example

SELECT * FROM hotel WHERE UPPER(name) = 'REGENCY'

Searching for values (case insensitive)

HNO

NAME

ZIP

ADDRESS

30

Regency

20037

477 17th Avenue

 

 

Leaving content frame