Functions

LOWER

Converts a string to all lower case characters.

Syntax

LOWER(string)

string
Required. The text string that will be shifted down.

Example

select
LOWER (contact) as low, UPPER(contact) as up
from customers where state = 'co'

Top