Home Forums SQL Server 2008 T-SQL (SS2K8) IF 0.00 then make it .00 RE: IF 0.00 then make it .00

  • January 28, 2015 at 7:38 am

    #1773684

    If I've understood correctly you just need to amend the select list for those two columns:

    ACTLABCOST = case when ACTLABCOST = 0.00 then .00 else ACTLABCOST end,

    ACTMATCOST = case when ACTMATCOST = 0.00 then .00 else ACTMATCOST end,