how to split comma separated string values into columns in sql server

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