Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
We receive a file from one of our partners that contains first and last name.
We need to order the file by name, but they send us mixed case names.
Is there a way to create an index of some type by using either the upper or lower function on the name fields?
I thought I had done this in Oracle SQL, but it could have been one of those dreams.
Thanks for your input.
Danny
In DDS, use: ALTSEQ(QSYSTRNTBL)
at the file-level.
In SQL, use: ORDER BY upper(lastname), upper(firstName)