Oracle sql subtring in case dont work : I have a query like this:

    SELECT id, (CASE WHEN com_column IS NULL THEN '' ELSE SUBSTR(com_column,0,50) || '...' END) AS ss From Table;

Any idea how to solve this?