AnsweredAssumed Answered

Add constraint comparing another field and NULL

Question asked by DamianMilne on May 14, 2019
Latest reply on May 22, 2019 by DamianMilne

Hi, I have two integer fields, "FIELD A" and "FIELD B". I am trying to add a constraint on "Field A"  that meets the following conditions:

 

If "Field B" IS NULL, "Field A" can be any value (including NULL)

If "Field B" IS NOT NULL, "Field A" must be greater than "Field B"

 

Can anyone assist with the syntax please?

 

Regards, Damian

Outcomes