Re: Switching NULL status

use a trigger on insert / update those 2 columns. the trigger will call a store procedure that will raise exception and fail if the row does not fit to the rule. Liat mdelerme@my-deja.com wrote: > Hi All, > > Question, Is there a way to set up, if (on the same table) column1 is > null than column2 must have a value and if column2 is null then column1 > must have a value? Would I use a constraint? If so, how might I go > about this. If not, any suggestions. Thanks in advance. > > Marco > > Sent via Deja.com http://www.deja.com/ > Before you buy.