AW: Dynamic pattern with embedded SQL.

Hi,

just change your Where-Clause as follows:
Where MLNAME Like TRIM(:Pattern)

Or Remove the leading and trailing % signs and change you where clause as
follows:
Where MLNAME like '%' concat TRIM(:Pattern) concat '%'

Or
Where PosStr(MLNAME, TRIM(:Pattern)) > 0

In either way it does not matter if :Pattern is defined as fixed or varying
length field or if the :Pattern field is completely filled with trailing %
signs.

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 Alan Campin
Gesendet: Friday, 03. April 2009 00:01
An: RPG programming on the IBM i / System i
Betreff: Dynamic pattern with embedded SQL.

I want to do the following. Am I going to have to create a dynamic SQL
statement?

Exec Sql Declare C1 Cursor For
           Select MLNAME,
                  MLMTXT,
                  MLSEU2
             From QTEMP/MBRLIST
             Where MLNAME Like :Pattern
             Order By MLNAME;

Pattern has something like '%LL%'

I have tried as above and

'''%LL%'''

They all return no records.

Thanks for any help.