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 .
This exercise is part of the course
Functions for Manipulating Data in SQL Server
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
company,
bean_type,
broad_bean_origin,
'The company ' + company + ' uses beans of type "' + bean_type + '", originating from ' + broad_bean_origin + '.'
FROM ratings
WHERE
-- The 'broad_bean_origin' should not be unknown
___ NOT LIKE '%unknown%';