[thelist] SQL Question - Drop the last charector of a string

[Casey Crookston]

I REALLY apprecciate the help.  I hope I didn't sound rude, pushy,
ingrateful, or demanding when I said this:

~~~~~~

So it's not just replacing the last character, it' replacing all
instances of the last character.  :-(  

As a reminder, this is what we need:

Main_heading	sub_heading
----------------------------------------
Appliances		Major-Used
Appliances		Major-Parts & Supplies
Appliances		Major-New
Appliances		Major-Service & Repair

For now let's forget about writing to the other table and just focus on
the correct SELECT statement.  I'll keep playing and trying.  And if
anyone else comes up with something, please do share!!!