SELECT * FROM imms_document  WHERE folder ('/Non Clinical',descend) 
AND (LOWER (object_name) LIKE'%sum%' 
OR LOWER (object_name) LIKE '%report%' 
OR LOWER (object_name) LIKE '%text%' 
OR LOWER (object_name) LIKE '%mad%' 
OR LOWER (object_name) LIKE '%final%' 
OR LOWER (object_name) LIKE '%ctd%' 
OR LOWER (object_name) LIKE '%complete%')
AND "r_creation_date" >= DATE('01/01/2006') 
AND "r_creation_date" < DATE('01/01/2007')
AND LOWER(title) LIKE '%toxicity%' 
AND LOWER(object_name) NOT LIKE '%old%'