Get startedGet started for free

Checking phone numbers

As you learned in this lesson, the underscore _ symbol matches any single character.

You want to prepare a script that checks every contact_number value from the series table to get those numbers that don't start with three fives followed by a hyphen as such 555-, then three characters followed by another hyphen and finally, another four characters (555-###-####).

Can you find them?

This exercise is part of the course

Cleaning Data in SQL Server Databases

View Course

Exercise instructions

  • Select the contact number.
  • Get the numbers of contacts that don't match the pattern.
  • Write the pattern that the numbers have to match.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

SELECT 
	name, 
    -- Contact number
    ___
FROM series
-- Get the numbers that don't match the pattern
WHERE contact_number ___ ___ 
	-- Write the pattern
	___
Edit and Run Code