PPT Slide

Using the lower( ), upper( ) and initcap( )

functions in SELECT statements:

Two straightforward examples of SQL queries

are sometimes referred to as "case translators”,

because they perform a simple translation of

case based on the text string passed:

SELECT LOWER(title) TITLE_NOQUOTE, UPPER(artist) ARTIST1,

INITCAP(artist) ARTIST2

FROM SONGS;TITLE_NOQUOTE ARTIST1 ARTIST2------------------- --------- ---------"happy birthday" ANONYMOUS Anonymous"diamonds and rust" ANONYMOUS Anonymous"amazing grace" ANONYMOUS Anonymous

11

Previous slide

Next slide

Back to first slide

View graphic version