Replacing and removing substrings
The REPLACE() function is a versatile function that allows you to replace or remove characters from a string. The syntax is as follows:
REPLACE(fieldName, 'searchFor', 'replaceWith')
Where fieldName is the field or string being updated, searchFor is the characters to be replaced, and replaceWith is the replacement substring.
In this exercise, you will look at one specific value in the countries table and change up the format by using a few REPLACE() functions.
Cet exercice fait partie du cours
Reporting in SQL
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
SELECT
region,
-- Replace all '&' characters with the string 'and'
____ AS character_swap,
-- Remove all periods
____ AS character_remove
FROM countries
WHERE region = 'LATIN AMER. & CARIB'
GROUP BY region;