Hi Chris many thanks for this and you are absolutely right about the productid. I can't sady do anything with this however your query does look good.

As I only gave a sample of the data how could this be used when there is no : in the title name?

thanks for all your help

Paul