How to remove the last three characters from a string?

Question

Hi Guys,

On the column country in my report i am getting the country like Italy/RF.

I need to remove the '/RF'. Tried TRIM, combination of SUBSTRING and LENGTH, but not getting it right.

any idea?

Jerry Casey · Answer

I don't know how it works on this new site, which I have found to be very frustrating.  I think you just marked your own answer as correct, though.

fabryddorf-Oracle · Answer

Great!! That worked!

how to i mark as solution provided?

Jerry Casey · Answer

Is it always "/RF"?  If it always starts with a slash, you can say LEFT("Table"."Country", LOCATE('/',"Table"."Country")-1)