Removing blank spaces
You can also find missing data represented with blank spaces ''
.
The comparison operators =
and <>
can help you to select or remove the rows when missing values are represented with blank spaces ''
.
The airport_city
column of the airports
table has some blank spaces. Try to find them!
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 *
-- Select the appropriate table
FROM ___
-- Exclude the rows where airport_city is missing
WHERE ___ ___ ___