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 - 1611 days ago
Last viewed on: 22 Jun 2017 (3362 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)

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 7 months 13 days 22 hours 38 minutes ago

In DDS, use:   ALTSEQ(QSYSTRNTBL)

at the file-level.

 

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