INITCAP(x)

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 produce an alphanumeric value are permitted as string specifications.

Result of the INITCAP(x) function

x is a NULL value

NULL Value

Examples

SQL Tutorial, Information About Character Strings