AW: Like statement within case statement

It will not work in this way!
You may try the following

Where YourFld like Case When :ParSnamshPath <> ' '
then '%' concat
Trim(Class.SnapshotPath) concat '%'
Else '%%' End;

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"


-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von Naveen Kapoor
Gesendet: Friday, 22.6 2012 17:22
An: rpg400-l@xxxxxxxxxxxx
Betreff: Like statement within case statement

Hello,

Case
When :parmSnapShPath <> ' '
Then
:parmSnapShPath like '%' || trim(Class.snapshotpath) || '%'
Else
class.snapshotpath = class.snapshotpath
End

For some reason it is not liking the like statement within the case
statement, is this a limitation? if yes is there is any solution for this.

Thanks in advance!

--
Regards
Naveen
--
This is the RPG programming on the IBM i / System i (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.