for datetime you can use CTOT() etc. but for memo I think to only option may be to create a cursor manually and add it into the SQL Arnon > what are the placeholders for memo fields and datetime fields in select > union statements? character and date don't seem to work... >