I have a table that has many Y/N flags.
Is there any way to set up one rule for all of these, or do I need to put a separate constraint on each field?

I tried to create a UDT and bind it to a rule where @value in ('Y','N')
but it never fired.

if I can do it in one step, please tell me how.

TIA

CREATE RULE Flag_Rule
AS
@Flg IN ('y', 'n')

sp_bindrule Flag_Rule, 'table1.flg'


finally i am asking ....
why not using bit type for each column 0/1 ???

Ahmed Ali
Software Developer