1. 学习
    2. /
  2. 课程
    3. /
  3. Cleaning Data in SQL Server Databases
Connected

练习

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.

说明

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