Discard last 3 characters of a field

Question

I want to extract the first (not last three) characters of a string from a table like:

Code
--------
CREF182
CXEF7U8
CEF7U8
CF777

How can I perform a query that will discard the last three characters of the string in a result so it shows something like:

Code
--------
CREF
CXEF
CEF
CF

I'm thinking this should be the Opposite of mysql RIGHT function? Any suggestions?

Answer 1

Try this one...

Syntax

SELECT SubStr(myColumn, 1, LENGTH(myColumn) - 3)
FROM MyTable

Example

SELECT SubStr(code, 1, LENGTH(code) - 3)
    FROM MyTable

Answer 2

How about:

SELECT REVERSE(SUBSTR(REVERSE(Code), 4)) as Code from YourTable;