1. Learn
  2. /
  3. Courses
  4. /
  5. Functions for Manipulating Data in SQL Server

Exercise

Changing to lowercase and uppercase

Most of the time, you can't make changes directly to the data from the database to make it look more user-friendly. However, when you query the data, you can control the aspect of the results, and you can make them easier to read.

Working with functions that manipulate string values is easy and gives great results. In this exercise, you will see how easy it is to work with the functions that transform the characters from a string to lowercase or uppercase. The purpose is to create a message mentioning the types of cocoa beans used by each company and their country of origin: The company BONNAT uses beans of type "Criollo", originating from VENEZUELA .

Instructions 1/3

undefined XP
    1
    2
    3
  • Select information from the ratings table, excluding the unknown broad_bean_origins.
  • Convert the broad_bean_origins to lowercase when comparing it to the '%unknown%' expression.