I had (have!) trouble deleting replicate Articles with SQLserver 2012 (11.0.3000.0) after a server rename.
That in turn does not allow me some table operations, notably truncate.
You should be able to get it by using an OUTER APPLY join plus TOP 1
(r.race=1 and r.program = 'gold')
r.race is null
case when r.race is null then 1 else 0 end
commission | program | race
---------: | :------ | ---:
14 | gold | 1
23 | gold | null