SELECT '(' || SUBSTRING(phone FROM 1 FOR 3) || ') ' || SUBSTRING(phone FROM 4 FOR 3) || '-' || SUBSTRING(phone FROM 7 FOR 4) FROM table;