RE: SQLRPGLE Invalid token Error

Try the ESCAPE keyword 

SELECT *
FROM TABLEY
WHERE C1 LIKE 'AAAA+%BBB%' ESCAPE '+'

See SQL Reference (v5r2 page 155 - 159)
http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/db2/rbafzmst.pdf


Thank you,
Matt Tyler
WinCo Foods, LLC
mattt@xxxxxxxxxxxxxx


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of PHarte@xxxxxxxxxx
Sent: Friday, December 09, 2005 9:02 AM
To: RPG400-L@xxxxxxxxxxxx
Subject: SQLRPGLE Invalid token Error 

Here's the situation......

 I have a prompt screen which I key a word to be searched for.

Here's the code which creates the SQL Statement

 * Create SQL Statement based on what's been keyed 
c                   eval      search ='%'+%trim(compny)+'%' 
c                   eval      mainstatement = 
c                             'select * from guser02 where ' + 
c                             'gubcap like ' + 
c                             '''' + %trim(search) + '''' + 
c                             ' order by gubusn for read only' 
 * 
Works like a charm 'til I key the search word which contains an 
apostrophe, for example St. John's, then I get an invalid token error 
based on the statement below.

select * from guser02 where gubcap like '%ST. JOHN'S%' order
 by gubusn for read only 

Any suggestions...TIA 
Pat.