I have a table with comma separated strings as data in one of itís columns. The string is always comma separated but it can have any number of tokens.
I want to split this string and then generate a view which holds each token separately in a different row. i.e I want to have only one system per row.
View : V_MyOrder
No procedures/functions please.
I would like to know what are all the systems associated with an order, one at a time, so that I can do a join with some other systems table that I have in my database to get more information.