How to split a column in SQL Server

Split a column in SQL Server to clean and reshape your data – ideal for separating names, codes, or values stored together.