Midrange News for the IBM i Community

Posted by: Danny Hayes
i developer
Tata Consultancy Services
Jacksonville, Florida
Can I use upper or lower to create an index
has no ratings.
Published: 09 Nov 2011
Revised: 23 Jan 2013 - 4101 days ago
Last viewed on: 14 Apr 2024 (5204 views) 

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.

Can I use upper or lower to create an index Published by: Danny Hayes on 09 Nov 2011 view comments(1)

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.


Return to midrangenews.com home page.
Sort Ascend | Descend


(Sign in to Post a Comment)
Posted by: bobcozzi
Site Admin ****
Comment on: Can I use upper or lower to create an index
Posted: 12 years 5 months 7 days 11 hours 10 minutes ago


at the file-level.


In SQL, use:  ORDER BY upper(lastname), upper(firstName)