<div>
In the results of a query?<br />
In the output of a report?<br />
When viewing tables interactively?<br />
Where do you want to view zero values as null or empty?
</div>


<div>
A integer datatype cannot be '' correct??
</div>


<div>
Hello Elucero!<br />
<br />
So I am going to say if you are trying to pull back a dataset that has a column [int] and where there exists 0 (Zero) you can do this.<br />
<br />
You can create a case statement like this:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42528894-1"><span>SELECT</span>
<span>CASE WHEN COL1 = 0 THEN '' ELSE CONVERT(varchar(20), COL1)  END  as 'Alias Name of Column'</span>
<span>FROM</span>
<span>TABLENAME</span>
</code></pre>
</div>


<div>
does it really have to be '' ?? would NULL be sufficient ? e.g.<br />
<br />
select case when column1 = 0 then NULL else column1 end as column1<br />
from yourtable<br />
<br />
otherwise you do have to convert the column to a string because '' is a string.
</div>


<div>
<div class="content wysiwyg-content">
How do I set an integer to blank '' &nbsp;when it's displayed as a 0?
</div>
</div>


How do I set an integer to blank ''  when it's displayed as a 0?

integer to blank

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.