ateneva
8/18/2018 - 11:20 AM

How do I change the case of a string?

How do I change the case of a string?

---------------------SQL Server----------------------------------------------------------------

select 

title,
lower(title) as lowercase_string,
upper(title) as uppercase_string

from datageeking.dbo.films

/*
title                       |lowercase_string            |uppercase_string            |
----------------------------|----------------------------|----------------------------|
ACADEMY DINOSAUR            |academy dinosaur            |ACADEMY DINOSAUR            |
ACE GOLDFINGER              |ace goldfinger              |ACE GOLDFINGER              |
ADAPTATION HOLES            |adaptation holes            |ADAPTATION HOLES            |
AFFAIR PREJUDICE            |affair prejudice            |AFFAIR PREJUDICE            |
AFRICAN EGG                 |african egg                 |AFRICAN EGG                 |
AGENT TRUMAN                |agent truman                |AGENT TRUMAN                |*/

---------------------MySQL-----------------------------------------------------------------------

select 

title,
lower(title) as lowercase_string,
upper(title) as uppercase_string,

lcase(title) as lowercase_string,
ucase(title) as uppercase_string

from sakila.film
 
/*
title                       |lowercase_string            |uppercase_string            |
----------------------------|----------------------------|----------------------------|
ACADEMY DINOSAUR            |academy dinosaur            |ACADEMY DINOSAUR            |
ACE GOLDFINGER              |ace goldfinger              |ACE GOLDFINGER              |
ADAPTATION HOLES            |adaptation holes            |ADAPTATION HOLES            |
AFFAIR PREJUDICE            |affair prejudice            |AFFAIR PREJUDICE            |
AFRICAN EGG                 |african egg                 |AFRICAN EGG                 |
AGENT TRUMAN                |agent truman                |AGENT TRUMAN                |*/

----------------------PostgreSQL--------------------------------------------------------------------
 
select 

title,
lower(title),
upper(title),
 
from public.film

/*
title                       |lowercase_string            |uppercase_string            |
----------------------------|----------------------------|----------------------------|
ACADEMY DINOSAUR            |academy dinosaur            |ACADEMY DINOSAUR            |
ACE GOLDFINGER              |ace goldfinger              |ACE GOLDFINGER              |
ADAPTATION HOLES            |adaptation holes            |ADAPTATION HOLES            |
AFFAIR PREJUDICE            |affair prejudice            |AFFAIR PREJUDICE            |
AFRICAN EGG                 |african egg                 |AFRICAN EGG                 |
AGENT TRUMAN                |agent truman                |AGENT TRUMAN                |*/