Error Diagnostic Information

Oracle Error Code = 904

ORA-00904: "MAKEVARCHAR2": invalid identifier

SQL = "SELECT count(*) content_count FROM content WHERE (status IS NULL OR status='Approved') AND ( scope LIKE '%3%' OR scope LIKE '%81%' OR scope LIKE '%22%' OR scope LIKE '%21%' OR scope LIKE '%36%' OR scope LIKE '%37%' OR scope LIKE '%38%' OR scope LIKE '%39%' OR scope LIKE '%40%' OR scope LIKE '%41%' OR scope LIKE '%42%' OR scope LIKE '%43%' OR scope LIKE '%35%' OR scope LIKE '%44%' OR scope LIKE '%45%' OR scope LIKE '%46%' OR scope LIKE '%47%' OR scope LIKE '%48%' ) AND (kbtype = 3) AND (lower(contentdesc) LIKE '%library%' OR lower(keyword) LIKE '%library%' OR lower(trim(MAKEVARCHAR2(comments))) LIKE '%library%' OR lower(link) LIKE '%library%') AND kbtype IS NOT NULL ORDER BY upper(contentdesc), contentdesc"

Data Source = "TLTC"

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (411:3) to (411:93).

Date/Time: Thu Jul 24 17:06:38 2003
Browser: ia_archiver
Remote Address: 209.237.238.173
Query String: kbtype=3&eventtime=future&focus=0&sort=alpha&allscopes=0&scope=3&keyword=library&format=condensed