1. Learn
    2. /
  2. Courses
    3. /
  3. Cleaning Data in SQL Server Databases

Exercise

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!

Instructions 1/2

undefined XP
  • 1
    • Use <> to return all the rows from the airports table where airport_city is not missing.
  • 2
    • Now, use = to return all the rows from the airports table where airport_city is missing.