How to convert comma-separated String to List?

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