In Sql developer ,How to remove the last 3 digit from string in all rows for one column? [closed]

Colum2

Karim_bk 
Karim_bk 
Karim_bk 

Want result Karim

Answer

This should work

select top 10 Lastname, LEFT(Lastname, LEN(Lastname) - 3) as TrimmedVersion  from tablename