DB2的查询sql有关问题_DB2

DB2的查询sql问题
SELECT ORG1.ID AS COMPID,ORG2.ID AS ORGID
FROM APPUSER.OAMP_ORG_ORGANIZATION ORG1 , OAMP_ORG_ORGANIZATION ORG2
WHERE ORG1.PARENTORGID = 1
AND ORG2.ORGPATH = '%'||RTRIM(LTRIM(CHAR(ORG2.ID)))||'%'

SQL报了下面的错误，请问如何解决呢？
[color=#FF0000]
19:32:08.843 DBMS CMS -- Error: [IBM][CLI Driver][DB2/AIX64] SQL0132N LIKE 谓词或 POSSTR 标量函数无效，因为第一操作数不是字符串表达式或第二操作数不是字符串。 SQLSTATE=42824[/color]

------解决方案--------------------------------------------------------
加%是为了使用like吧？
AND ORG2.ORGPATH like '%'||RTRIM(LTRIM(CHAR(ORG2.ID)))||'%'
------解决方案--------------------------------------------------------
AND ORG2.ORGPATH = '%'||RTRIM(LTRIM(CHAR(ORG2.ID)))||'%'

PATH 看名称好象是个路径,%s??
------解决方案--------------------------------------------------------

SQL code

SELECT ORG1.ID AS COMPID,ORG2.ID AS ORGIDFROM APPUSER.OAMP_ORG_ORGANIZATION ORG1 , OAMP_ORG_ORGANIZATION ORG2WHERE ORG1.PARENTORGID = 1AND LOCATE (RTRIM(LTRIM(CHAR(ORG2.ID))),ORG2.ORGPATH)>0
------解决方案--------------------------------------------------------
% 要用转义吧，我猜测。不知道你想搜索什么，条件是什么。