Re: Embedded RPG and the WHERE LIKE

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?)