I have to extract a report from one of the database table. I have an issue with one of the column which is having a decimal value.
The user wants that if the value of this field is '0' then it should be reflected as 'SPACES' in the final report.
The datatype of this column is DECIMAL(9,2). I tried converting this column to character first using CHAR function and then trying to REPLACE the values but in vain. I am creating the report using the STRIP function and tried using the belwo query: