전화번호, 이메일 분리

기존 DB 에서 전화번호, 이메일 분리
010-1234-5678 >>> 010, 1234, 5678
test@aaa.com >>> test, aaa.com
어휴 눈아퍼

SELECT SUBSTRING(MOBILE, 0, CHARINDEX('-', MOBILE)) AS MOBILE_01
     , SUBSTRING(SUBSTRING(MOBILE, CHARINDEX('-', MOBILE)+1, LEN(MOBILE)), 0, CHARINDEX('-', SUBSTRING(MOBILE, CHARINDEX('-', MOBILE)+1, LEN(MOBILE)))) AS MOBILE_02
     , SUBSTRING(SUBSTRING(MOBILE, CHARINDEX('-', MOBILE)+1, LEN(MOBILE)), CHARINDEX('-', SUBSTRING(MOBILE, CHARINDEX('-', MOBILE)+1, LEN(MOBILE))) + 1, LEN(MOBILE)) AS MOBILE_03
     , SUBSTRING(EMAIL, 0, CHARINDEX('@', EMAIL)) AS EMAIL_01
     , SUBSTRING(EMAIL, CHARINDEX('@', EMAIL) + 1, LEN(EMAIL)) AS EMAIL_02
FROM 테이블 명