Almost half of farmers in the North admit they have nobody in mind to take over their farms when they retire.