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 |
SQL Tutorial, Information About Character Strings