Use the below code:

SELECT

ISNULL(x.y.value('Display[1]', 'VARCHAR(30)'),'') AS col1,

ISNULL(x.y.value('Display[2]', 'VARCHAR(30)'),'') AS col2,

ISNULL(x.y.value('Display[3]', 'VARCHAR(30)'),'') AS col2,

ISNULL(x.y.value('Display[4]', 'VARCHAR(30)'),'') AS col2,

ISNULL(x.y.value('Display[5]', 'VARCHAR(30)'),'') AS col2

FROM

(SELECT CAST('<aa><Display>'+REPLACE(DisplayName,'/','</Display><Display>')+'</Display></aa>' AS XML) as Display FROM TEMP# )cte

CROSS APPLY cte.Display.nodes('aa') x(y)

Praveena