Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community

At 14 MAR 2022 02:11:24PM Donald Bakke wrote:

Is there a way use LIST to perform a case-insensitive sort by a column? I don't want to use a calculated column or index to accomplish this. I just want a simple case-insensitive sort. The CASESENS and CASEINSENS keywords only seem to support searches (i.e., the WITH keyword)

Don Bakke

SRP Computer Solutions, Inc.


At 14 MAR 2022 02:37PM bob carten wrote:

I don't think there is a way to make a LIST statement perform a case insensitive sort.

RLIST calls EXTERNAL.SORT, which calls V119. I don't see anything which mentions case sensitivity in those programs.


At 14 MAR 2022 02:41PM Donald Bakke wrote:

I don't think there is a way to make a LIST statement perform a case insensitive sort.

RLIST calls EXTERNAL.SORT, which calls V119. I don't see anything which mentions case sensitivity in those programs.

Thanks for confirming. I was surprised that I had never encountered this in over 30 years, so I was assuming I had forgotten or missed smoething.

Don Bakke

SRP Computer Solutions, Inc.

View this thread on the Works forum...

  • third_party_content/community/commentary/forums_works/d2ac791dd79f6344b31314c27c5b46b1.txt
  • Last modified: 2023/12/30 11:57
  • by 127.0.0.1