know how to parse data from single column??

Hello,

I have a query that is selecting a column where the data is as such:

1|5|6
3|11|12|7

...etc...

essentially the specific data points within the column are all seperated by pipes.

Anyone know how to select out these specific data points so they appear in, ideally, their own columns?

Thanks,

Mike Received on Tue Oct 29 2002 - 16:36:01 CST