> logically_deleted_yn= ;
> IIF(INLIST(logically_deleted_yn,"Y","N"),;
> logically_deleted_yn,.NULL.)

Steve,

Trey's answer to you is correct...

Your expression looks like an attempt to assign a value to logically_deleted_yn. No assignment is made in this expression; the total expression is evaluated.

Your expression will always evaluate to TRUE or NULL (never FALSE). It will evaluate to TRUE when logically_deleted = "Y" or "N", and to .NULL. in all other cases. The RI mechanism has been written to FAIL only on FALSE (as opposed to PASS only on TRUE).

For a discussion on this, see thread #398289, where George talks about this apparent weirdness.