split function in sql

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