Is the NALAST field a variable length also? If not, that is probably your problem. You may need to also trim NALAST in the where clause.
Denis Robitaille
Chef de service TI
Cascades Centre des technologies,
une division de Cascades Canada ULC
412 Marie Victorin
Kingsey falls(Québec) Canada J0A 1B0
T : 819 363 6130
-----Message d'origine-----
De : RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] De la part de Booth Martin
Envoyé : 16 novembre 2015 16:45
À : RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxx>
Objet : Re: AW: Embedded RPG and the WHERE LIKE
Lots of good answers. Thanks Birgitta, Vern, Peter, Brian, Mike, and M Price.
However....
Smi% works. %mit% works. %ith does not work. Further testing shows that Smith does not work either. It would seem to me that these would all work or, none?
The code is:
...
d wSRCHLAST s 35 varying
...
wSRCHLAST = %trim(SRCHLAST);
...
where NALAST like :wSRCHLAST
...
By the way, glad I asked about case sensitive. "exec sql set option SRTSEQ = *LANGIDSHR;" seems to have rung that bell. Thanks for that suggestion.
On 11/16/2015 12:10 AM, Birgitta Hauser wrote:
I assume there are trailing blanks in your original field that are not
trimmed off.
If you specify '%ith' exactly the last 3 characters in your original
field have to be ith.
You may try WHERE RTrim(YourColumn) like '%ith'
Or WHERE Right(RTrim(YourColumn), 3) = 'ith'
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
--
This is the RPG programming on the IBM i (AS/400 and 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.
midrange.com
