子查询 title 中Memo或ole对象无效

"SELECT * FROM NC_daily WHERE title in (select cstr(OID) from [NC_objInfo] where ShipNumber  like '%" + key + "%' or EnglishName like '%" + key + "%' or Nationality like '%" + key + "%') or BasicDesc like '%" + key + "%' or Suggest like '%" + key + "%' order by CreatTime desc";

 

查询语句如上，title开始是备注类型

就报标题那个错

把title的数据类型由“备注”改成“文本”后解决了此问题

深层原因不清楚....