Problem solve Get help with specific problems with your technologies, process and projects.

"Caseless" search and sort in query

Here's a way to run AS/400 query sorts and searches that aren't case-sensitive.

AS/400 query sorts and searches using the hexidecimal values of characters, by default. This makes sorts and searches case-sensitive. You can change this.

An AS/400 query, by default, uses "Collating Sequence" = 1, Hexidecimal. That means if you are looking, e.g., for a string = "Printer", you have to also look for "printer" and "PRINTER", if you are unsure of case.?

If you select "Collating Sequene" = 2, Query for AS/400 English, the search and sort operations are not case sensitive. "printer" will find all variations, and A and a, B and b, etc., will sort together.


 

Dig Deeper on RPG iSeries programming

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close