Thanks for your help. I used the alltrim option and it works unless there is more than a few lines of text in the memo field, in which case I get an error message saying 'string is too large'. Presumably this is because the width of the column limits the size of the string?