Wednesday 18 February 2015

The INITCAP Function in SQL

INITCAP returns character, with the first letter of each word in uppercase, all other letters in lowercase. The following example converts the first letter of the job id column to uppercase, and the rest to lower case. Note that the values stored in this table column are all upper case.

    Syntax 
INITCAP (character)


    SQL Statement :
SELECT      INITCAP(job_id)
FROM         employees;


    Output :









No comments:

Post a Comment