RE: Using LIKE Operator in SQLRPGLE ?

I thought that after I posted. It seems like the single-quotes also need to
be inside the variable or something.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, February 16, 2005 2:19 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Using LIKE Operator in SQLRPGLE ?


That doesn't seem to work.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Martin, Steve (MAN-Golden)" <Steve.Martin@xxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
02/16/2005 03:48 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"'RPG programming on the AS400 / iSeries'" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
RE: Using LIKE Operator in SQLRPGLE ?






Can you use an EVAL statement to append the '%' to CID just before the 
SQL?

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Luqman
Sent: Wednesday, February 16, 2005 1:30 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Using LIKE Operator in SQLRPGLE ?


How can I use LIKE Operator in SQLRPGLE ?

I tried following but its giving error.

CID is a string variable.

C/ EXEC SQL
C+ SELECT * FROM INVOICE WHERE CUSTID LIKE :CID ||'%'
C/END EXEC

Best Regards,

Luqman





-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.


-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.