Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In Example 12-1, the logical function lt_city failed to sort APO and Anywhere in proper order because all capital letters appear before all lowercase letters
In Example 12-1, the logical function lt_city failed to sort APO and Anywhere in proper order because all capital letters appear before all lowercase letters in the ASCII collating sequence. Add an internal procedure to function lt_city to avoid this problem by shifting both city names to uppercase before the comparison. Note that this procedure should not shift the names in the database to uppercase. It should only shift the names to uppercase temporarily as they are being used for the comparison.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started