How do I separate a comma separated string in SQL?

SQL Server CHAR data type is used to store non-Unicode string data of fixed-length.