SQL Query Convert CSV Column to Rows

Suppose we have Comma Separated value in Column and want to convert to Row

SQL Query to Covert ItemID into Row
 

SELECT Distinct AreaID, RequestID,

Split.a.value('.', 'VARCHAR(100)') AS ItemID , ModifiedDate, CreatedDate

FROM (SELECT

CAST ('<M>' + REPLACE([ItemID], ',', '</M><M>') + '</M>' AS XML)

AS ItemID , RequestID , AreaID , ModifiedDate, CreatedDate

FROM RequestItems_Graphics) AS A CROSS APPLY ItemID.nodes ('/M') AS Split(a)


Result