Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  change zeros to blanks in final table

Author  Topic  ssingh Starting Member 25 Posts Posted - 2001-09-12 : 12:32:26 I'm writing stored proc which creates a report. In my final table which displays the report I have datatype int which displays 0 if there are no values. How can I instead display blanks/space I tried SELECT CASE WHEN COL_NAME = 0 THEN CONVERT(VARCHAR(4),'') ELSE COL_NAME END AS ABC INTO FINAL_TBL FROM #TEMP_TBL But this also displays zeros