Concatenating cities and states
In the previous exercise, you used the +
operator to combine two columns into one. This time you need to do the same, but using the CONCAT()
function.
To get this format for the concatenation: 'Las Vegas, Nevada'
, you will need to use the CASE
expression in case the state
column has NULL
values.
This exercise is part of the course
Cleaning Data in SQL Server Databases
Exercise instructions
- Concatenate the names of the cities with the states using the
CONCAT()
function, while using aCASE
statement that returns''
whenstate
isNULL
and performs a normal concatenation otherwise.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
client_name,
client_surname,
-- Use the function to concatenate the city and the state
___(
___,
CASE WHEN state IS NULL THEN ''
ELSE ___(', ', ___) END) AS city_state
FROM clients