>>hi
>>
>>I've got table of values
>>
>>ABF ASIA BUSINESS FORUM
>>ABF2028S ABF - OIL SPILL
>>ABF2033S ABF - BRAND MANAGEMENT
>>ABF2036S ABF - ONLINE REPUTATION
>>
>>and I want to select out this format.
>>
>>ABF ASIA BUSINESS FORUM
>>ABF ABF2028S ABF - OIL SPILL
>>ABF ABF2033S ABF - BRAND MANAGEMENT
>>ABF ABF2036S ABF - ONLINE REPUTATION
>>
>>I'm not sure how to achieve that so if you have any ideas.
>>
>>Nick
>
>Can you explain better what you are trying to do?

Hi Walter

I think i have it right now thanks

a mixture of union and cross apply

Nick