I have a SQL doing a UNION. The first part of the SQL is including a Url field which is a memo field. The second part of the SQL takes its data from another table where the Url is a character field. Now, that one field has been changed to a memo field, this SQL doesn't work. How can I make this SQL works?