IIf([Column1]=0,[Column2],[Column1])

select case
        when TABLE1.[COLUMN1]=0 then TABLE1.[COLUMN2]
    else TABLE1.[COLUMN1]
    end as SomeColumn