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

exercițiu

Using RIGHT() , LEFT() and REVERSE()

In the previous exercise, you used SUBSTRING() and CHARINDEX() to split the city_state column into two new columns.

This time you need to do the same, but using the LEFT(), RIGHT(), and REVERSE() functions.

Instrucțiuni

100 XP
  • Extract the name of the city using LEFT() and CHARINDEX().
  • Extract the name of the state using RIGHT(), CHARINDEX() and REVERSE().