From the course: SQL: Data Reporting and Analysis

Unlock the full course today

Join today to access over 23,400 courses taught by industry experts.

Challenge: Convert case

Challenge: Convert case - SQL Tutorial

From the course: SQL: Data Reporting and Analysis

Start my 1-month free trial Buy for my team

Challenge: Convert case

“

(bright music) - [Narrator] For our next challenge, you're still working at the Movie Rental Empire, but this time you are building a report for senior management. This challenge is only going to return the very first bit of data for that report, and that is the title field from the film table. You're going to report all the titles from the field table, the thing is you want them in proper case. That means you need to capitalize the first letter and make the remaining letters of the title field lowercase. Let's have a look at an example here. So the objective is to convert the title field of the film table to proper case, and underneath you can see a table where we start with everything in uppercase, and it's been converted to proper case. This should take you about five minutes.

Contents