The function INITCAP, issued on a character string, produces a character string where the first letter of each word is output as upper case character and the following letters are output as lower case characters. This function can be used, e.g., to unify the notation of names.
SELECT name, INITCAP (name) name_new
FROM customer
WHERE firstname IS NULL
