spin (11/7/2013)

---

Hi

i have the following field in a progress db which contains analysis codes for a given account. I need to split the codes into their own columns.

here's an example: 007;007;01D;P;999;999;

I am using the following to get the position of the ; character and then using substing to try and pull out the parts. The code is becoming painful already though and i'm only at the 3rd code.

Is there an easier way to do this?

charindex(';', analcode) pos1,

charindex(';', analcode, charindex(';',analcode)+1) pos2,

charindex(';', analcode, charindex(';', analcode, charindex(';',analcode)+1)+1) pos3

Thanks