Matt, potential problems in your states program.by (Login emoneo)
You enter the state names as such. How about the spelling of these, e.g.,
How many "s" and "t" in Massachusetts?
How many "s" and "p" in Mississippi?
How many "n" in Connecticut?
If the names of the states are not spelled correctly, then you will not be able to determine duplicates, and you will not be able to delete a state (unless you know the original spelling.) Given this type of error, you could end up with 50 state names which don't match the real 50 names of the states, or actually have less than 50 valid state names in your array.
One possible solution is to use the official USPS abbreviations for the states. But, this gets tricky because states beginning with "M" or "N" do not necessary have intuitive abbreviations.
I'll let you think about this. You might ask your teacher about it.
Return to Index
|Response Title||Author and Date|
|Extract characters to compare||Solitaire on May 24|
|* You're right Solitaire, it can get tricky.||on May 25|
|re:extract characters||Matt on May 28|
|Try using the SOUNDEX function.||on May 25|