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

[Casey Crookston]

Jason,

Okay.  We're on the right track here.  Thanks for your help.

SELECT * FROM temp_headings 

returns these rows (among many other):


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

But this query:

SELECT main_heading,
REPLACE(sub_heading,right(sub_heading,1),'') AS sub_heading
FROM temp_headings

Returns the above rows as this:

Main_heading	sub_heading
----------------------------------------
Appliances		MajorUsed	
Appliances		MajorParts & Supplies	
Appliances		MajorNew	
Appliances		MajorService & Repair

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!!!

Casey