CASE in Query

This is about CASE as in Upper or LOWER CASE.

Sometimes we have data in fields with upper and lower case, and we want to ignore the case when it comes to accessing or sequencing the data.

In WRKQRY main definition options, select # 6 Collating Sequence, then on the next panel, select System Sort Sequence. Leave the 2 lines on bottom blank & press enter.

This gets us to a new screen defaulted to *JOBRUN on bottom and we put option 3 Shared on the field up top.