Source code Copy code SELECT EMPLOYEE_ID,CONCAT(LEFT(PHONE_NUMBER,4),"xxxxxx",SUBSTR(PHONE_NUMBER ,11)) FROM employees;
Add your comment