SQL SEPARETE FOR SP : ABOUT : SQL MANAGEMENT STUDIO STORAGE PROSEDURE 

The following variables  '|' I want to separate it from . How can I do it.

'628391|28100|8304|3|1201129|12|Kg|M01|SERIOUSLY CHUNKY WOOL' 

'627452|70462|618|60|100059|72|Ad|M01|THICK & QUICK STRIPES'

'617213|99233|89|10|18754|12|Kg|M01|FASHION KC ARAN 400'