Use the INITCAP function to replace
the first letter of every word in a character string with an uppercase
letter. The INITCAP function assumes a new word
whenever the function encounters a letter that is preceded by any
character other than a letter. The INITCAP function
accepts an argument of a character data type and returns a value of
the same data type as the argument you specify.
The following
query uses the INITCAP function to convert the
first letter of every word in a character string to an uppercase letter.Figure 1: Query
SELECT INITCAP(description) FROM stock
WHERE manu_code = "ANZ";