Get startedGet started for free

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

View Course

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 ___ ___ ___
Edit and Run Code