At 02:51 PM 31/10/2003 +0000, you wrote:

>what is the correct syntex for this? I've tried a number of different
>ways:
>
>ALTER DOMAIN dm_MyDomain value in (1, 2, 3, 4, 5, 6)

This needs a CHECK constraint. If you already have a CHECK constraint on
the domain, you can't add another one. You can have multiple CHECK
conditions but they all have to be defined at once.

If you don't have one already, you can do
ALTER DOMAIN dm_MyDomain
add constraint CHECK (value in (1,2,3,4,5,6));

h