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.
x |
Result of the INITCAP(x) Function |
---|---|
x is a NULL value |
NULL value |
SQL Tutorial, Information About Character Strings