Oracle - SQL - Strings - Trim from end of string

substr(STRING_NAME,1,LENGTH(STRING_NAME)-3)