Query to match a pattern in sql

SELECT
id, name, father_name, dept_title, des_title, bps, cnic
FROM mis_emp_view
WHERE cnic LIKE '_____-_______-_%'