Solved programming problem

Show each employees first_name and phone_number(format: 515.xxx.xxx7)

Source code

SELECT EMPLOYEE_ID,CONCAT(LEFT(PHONE_NUMBER,4),"xxxxxx",SUBSTR(PHONE_NUMBER ,11))

FROM employees;
Join the discussion

Add your comment