SQL server express Pipe delimiter value need to be split into appropriate columns:

Hi SQL gurus,

I need to thank you ahead of time for even reading this post as I am a newb to SQL server. Below is a field in a database that has a delimiter of "|" and I need to break up that value every time the "|" appears. Can this be done automatically without using CHARINDEX or SUBSTRING....  Also the value in the data base will be applied to a large table that ho ...