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