c1 c2 c3 1 2 NULL 2 3 NULL 3 4 NULL 4 5 NULL
c1 c2 c3 1 2 NULL 2 3 1 3 4 2 4 5 3
select c1,c2,case when (c1-1)=0 then NULL else (c1-1) end as C3 from tblnm
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)