No, missing () around lastname,1,5. Also, a better plan is to give the column an alias. The statement should look like this: SELECT SUBSTR(LASTNAME,1,5) NAME FROM NAME_TBL;