Re: Embedded RPG and the WHERE LIKE

[Peter Dow <petercdow@xxxxxxxxx>]

Hi Booth,

To add to Birgitta's answer and answer your 2nd question, you can use 
either LCASE() or UCASE to convert strings to all lower case or all 
upper case, then make your constant match that:

WHERE lcase(RTrim(YourColumn)) like '%ith'

or

WHERE ucase(RTrim(YourColumn)) like '%ITH'

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx>

/
On 11/15/2015 9:22 PM, Booth Martin wrote:
> SQL has opened pleasing choices, choices which may bite me in the 
> end.  In the meantime though I am liking the LIKE.
>
> The instructions say one thing; I am getting another thing, which 
> probably means I didn't see some paragraph somewhere.
>
> As I understand it this is a valid statement:
>
> "Select:  "%" is wildcard (Smi% gets Smith, as does %ith and %mit%.) 
> Case sensitive."
>
> 2 out of 3 work.  Smi% works. %mit% works.  %ith does not work. The 
> field is defined as varying.  Does anyone recognize what has gone wrong?
>
> (As an aside, is there a way to make this not case sensitive?)