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