Re: AW: Embedded RPG and the WHERE LIKE

[Booth Martin <booth@xxxxxxxxxxxx>]

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