The INITCAP function

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";

Figure 2. Query result

(expression)

Tennis Racquet
Tennis Ball
Volleyball
Volleyball Net
Helmet
Golf Shoes
3 Golf Balls
Running Shoes
Watch
Kick Board
Swim Cap