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 - 1526 days ago
Last viewed on: 29 Mar 2017 (3222 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?

Undecided

I thought I had done this in Oracle SQL, but it could have been one of those dreams.

Thanks for your input.

Danny

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

COMMENTS

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

In DDS, use:   ALTSEQ(QSYSTRNTBL)

at the file-level.

 

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