How To Split Up Text In A Column

[yoursurrogategod]

Hi, I have this piece of text that is stored in our MS-SQL database (ignore the quotes and no, I can't redesign how this work specifically):

"TEST|00000298398293|EQ5|Patient"

 

Now, when I do a simple select, I get that result being returned. What I'd like to do is split that string based on the "|" character and return the individual strings associated with this string, so that I could have "TEST", "0000298398293", "EQ5" and "Patient" in different fields. How can I do this? In PHP, you can use the explode method, is there something like that in MS-SQL?

[yoursurrogategod]

I found this solution elsewhere:

DECLARE @Sql varchar(50) = 'TEST|00000298398293|EQ5|Patient'

 

This only works if you have 3 pipes

 

 

SELECT PARSENAME(REPLACE(@sql,'|','.'),4)

,PARSENAME(REPLACE(@sql,'|','.'),3)

,PARSENAME(REPLACE(@sql,'|','.'),2)

,PARSENAME(REPLACE(@sql,'|','.'),1)