Query-Split

Try this,

;WITH CTE AS (
        SELECT 
        PARSENAME(REPLACE([CODE],'-','.'),4) COL1,
        PARSENAME(REPLACE([CODE],'-','.'),3) COL2,
        PARSENAME(REPLACE([CODE],'-','.'),2) COL3,
        PARSENAME(REPLACE([CODE],'-','.'),1) COL4
        FROM (
                Select 'AXDE-123-YERT-RTEF' AS Code
                UNION ALL
                Select '648-WDSA-YUFG-BSFD' AS Code
                UNION ALL
                Select 'YUDF-AGAG-724-TERG' AS Code
                UNION ALL
                Select 'SHDF-UHDF-QWDF-345' AS Code
        ) X
),CTE1 AS (
        SELECT * FROM CTE
        UNPIVOT(VALS FOR COLS IN (COL1,COL2,COL3,COL4)) UVPT
)
SELECT VALS AS COLUMNS FROM CTE1 WHERE ISNUMERIC(VALS) <> 0

---

Regards, RSingh