要大寫的文字- The text which will be returned with the first letter of each word in uppercase and all other letters in 小寫
PROPERis useful for proper nouns, such as names of people or geographic locations.
PROPERcapitalizes each word in
要大寫的文字rather than the beginning of each sentence, and is therefore likely not the correct tool to use for paragraphs or other blocks of text.
PROPERwill convert all characters not at the beginning of words to lowercase, which may cause problems with certain strings. 時間範圍example, using
PROPER("mcLeod")to capitalize the surname McLeod results in "Mcleod" instead.