in reply to Peculiar Behaviour with DBI and MySQL
Thanks very much for the help you all offered.
I have since realised that it is something else causing the problems, not the database.
I've moved on to a different query now.
Thanks again
Chris