At 09:27 AM 20/04/2005 +0000, you wrote:

> >
> > CHECK (TheValue is null or TheValue in (1,2)). Of course, this check
> > constraint is not valid if the column TheValue is declared as NOT NULL.
>
>Thanx for the info, so if I insert the null in all my checks I wont
>have any conflicts between NOT NULL on the column and the NULL in the
>check, and NOT NULL is always evaluated before the check? The erd tool
>we use has globaly declared check constraints. So that would save me
>some time editing the schema.

That's not what I said.

>Alexander
>
>Ps: Something different, and I do not know where to ask/mention. This
>groep shows http://firebirdsql.org as website, that url doesn't work.
>www.firebirdsql.org does.

Thks, will fix it.

./hb