I've a data in the table which has 0 value for certain number of columns; but, the requirement is to display NULL if 0, I've many such columns and converting like this is causing performance issue, I've to do it at the db end only in the SP which returns the data

with the below statement it is working fine but, at the stake of performance.  do you've any better replacement or idea for this.

I've used 

CASE [Col1] WHEN 0 THEN NULL ELSE [Col1] END AS [ColumnFirst],

Take a look at NULLIF function in BOL.

NULLIF(Col1, 0) as Col

But basically, it's the same thing and should not affect the performance if these columns are used in the select stat

Hi Naomi,

I am looking for NULLs if actual value is 0

Hi Naomi,

I am looking for NULLs if actual valu