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 INITCAP(x) function | |
x is NULL value |
NULL value |
Model table:
Standardizing the notation for names
SELECT name, INITCAP (name) new_name
FROM customer WHERE firstname IS NULL
NAME |
NAME_NEW |
DATASOFT |
Datasoft |
TOOLware |
Toolware |