RE: SQLRPG with LIKE

[<Rick.Chevalier@xxxxxxxxxxxxxxx>]

What value is in FIC?  SQL wants something like this 'value%'.  If FIC contains 
the value only without % it will fail.  There is another special character that 
works with LIKE but I can't recall it at the moment.

Rick

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Damien Spriet
Sent: Wednesday, November 17, 2004 8:17 AM
To: 'rpg400-l@xxxxxxxxxxxx'
Subject: SQLRPG with LIKE


I'm trying to use LIKE in the SELECT on my SQLRPGILE pgm but it doesnt't
work why ? 
If I put equal works well. 

C* 
C *ENTRY PLIST 
C              PARM BIB 10 
C              PARM FIC 10 

C/EXEC SQL 
C+ DECLARE A CURSOR FOR 
C+ SELECT DBXFIL, DBXLIB, DBXATR, DBXTYP, DBXTXT 
C+ FROM QADBXREF 
C+ WHERE DBXATR = 'PF' AND DBXLIB = :BIB AND DBXFIL 
C+ LIKE :FIC 
C/END-EXEC 

C/EXEC SQL 
C+ OPEN A 
C/END-EXEC