Entering content frame

INITCAP(x) Locate the document in its SAP Library structure

INITCAP(x) is a string function that changes a character string x (string specification) so that the first character of a word is an uppercase letter and the rest of the word consists of lowercase characters. Different words are split by one or more characters from the 7-bit ASCII character set that are not letters or digits (such as commas, blank characters, or colons). For a list of letters and characters, see Character (character). Only expressions that supply an alphanumeric value are permitted as string specifications.

 

Result of the INITCAP(x) Function

x is a NULL value

NULL value

 

Example

SELECT name, INITCAP(name) name_new
  FROM customer
    WHERE firstname IS NULL

Standardizing the notation for names

NAME

NAME_NEW

Datasoft

Datasoft

TOOLware

Toolware

 

 

Leaving content frame