SELECT CASE LEN(phone) WHEN 11 THEN LEFT(phone, 1) + STUFF(STUFF(STUFF(phone, 1, 1, ‘ (‘), 6, 0, ‘) ‘), 11, 0, ‘-‘) WHEN 10 THEN STUFF(STUFF(STUFF(phone, 1, 0, ‘ (‘), 6, 0, ‘) ‘), 11, 0, ‘-‘) WHEN 7 THEN STUFF(phone, 4, 0, ‘-‘) ELSE ‘Invalid phone’ END AS ‘Formatted Phone’…