What would be the correct to verify the values for combination of OpName & Sponsor & KeyOrSpecialty must be unique unless if OpName = 'New Master Description'.
Would this be correct? Rules 'Value for the combination of OpName, Sponsor, and KeyOrSpecialty must be unique' FOR OpDescription SUCCEEDS WHERE (OpName & Sponsor & KeyOrSpecialty)IS NOT NULL AND (OpName & Sponsor & KeyOrSpecialty) NOT IN (SELECT (OpName & Sponsor & KeyOrSpecialty) FROM OpDescription #T1 WHERE #T1. (#t1.OpName & #t1.Sponsor & #t1.KeyOrSpecialty) = (OpDescription.OpName & OpDescription.Sponsor & OpDescription.KeyOrSpecialty)) AND OPName <> 'New Master Description'
