Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Reporting with SQL!
You have completed Reporting with SQL!
Preview
There are two functions for changing cases, UPPER() and LOWER(). Let's look how to use them.
Use the UPPER() function to uppercase text.
SELECT UPPER(<value or column>) FROM <table>;
Use the LOWER() function to lowercase text.
SELECT LOWER(<value or column>) FROM <table>;
Cheat Sheets
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
For example, make all the text in a column
uppercase or all the text lowercase.
0:00
The two most common uses
are to standardize output and
0:01
when searching for values.
0:05
There are two functions for
changing cases.
0:08
Upper for uppercasing values or columns.
0:10
Lower is used for
making lower case strings.
0:14
Let's see them in actions.
0:18
Let's say we wanted to bring up
a customer's records based on their
0:20
email address.
0:24
Let's run this query.
0:25
Notice how the email
address has a capital A.
0:29
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up