Thanks for that..had a look.

The execution plans were identical.

I tried varying the indexes on this table. One index in particular was dropped and it cured the problem....the query now runs in about 5 minutes instead of an hour.

Funny thing is the same indexes exists on a similar test system and that runs ok??

Thanks again..Graeme