Untitled

SELECT CONCAT(SUBSTRING(REPLACE(mac, ':', ''),1,4),'.',SUBSTRING(REPLACE(mac, ':', ''),5,8),'.',SUBSTRING(REPLACE(mac, ':', ''),9,12)) AS ciscomac FROM vmacs