INITCAP(x) 
INITCAP(x) is a string function that changes a character string in such a way that the first character of a word is an uppercase letter and the rest of the word consists of lowercase characters. Words are separated by one or more characters which are neither letters nor digits.
|
|
Result of the Function INITCAP(x) |
|
x is NULL value |
Example table: customer
Standardizing the notation for names
SELECT name, INITCAP(name) new_name
FROM customer WHERE firstname IS NULL
|
NAME |
NEW_NAME |
|
DATASOFT |
Datasoft |
|
TOOLware |
TOOLware |