Oracle/PLSQL: Lower Function

In Oracle/PLSQL, the lower function converts all letters in the specified string to lowercase. If there are characters in the string that are not letters, they are unaffected by this function.

The syntax for the lower function is:

lower( string1 )

string1 is the string to convert to lowercase.

Applies To:

• Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

For example:

lower('Tech on the Net');	would return 'tech on the net'
lower('GEORGE BURNS 123   ');	would return 'george burns 123   '