Combining cities and states using +
In this lesson, you learned how to combine columns into one.
The clients
table has one column, city
, to store the cities where the clients live, and another column, state
, to store the state of the city.
| client_id | client_name | client_surname | city | state |
|-----------|-------------|----------------|-----------|----------|
| 1 | Miriam | Antona | Las Vegas | Nevada |
| 2 | Astrid | Harper | Chicago | Illinois |
| 3 | David | Madden | Phoenix | Arizona |
| ... | ... | ... | ... | ... |
You need to combine city
and state
columns into one, to have the following format: 'Las Vegas, Nevada'
.
You will use +
operator to do it.
This exercise is part of the course
Cleaning Data in SQL Server Databases
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT
client_name,
client_surname,
-- Concatenate city with state
___ + '___' + ___ AS city_state
FROM clients