Thank you for taking the time to reply.
That doesn't seem to be it because I've tried variations which return both few and 1000's e.g. LIKE "N*" and NOT LIKE "N*" both return 1000's of records but the LIKE filter takes infinitely longer!
I've worked around the problem but I just cant...