SELECT
    item_code
    ,substr(trim(item_name),1,10) as ITEM_NAME
FROM
    tbl_item
ORDER BY
    item_code desc;