How to create a rule?

[sqlval]

I need to create a rule that one table field should be populated if there is a particular value in another field: if col1 = "Value" then col2 is not null. How do I do it? Is it a rule or an expression in the computed column property?
Thank you for your help.

 

[gmmastros]

Sounds like you need to add a constraint to your table. Something like this....

Alter Table    [!]YourTableName[/!] 
Add Constraint [!]NameOfConstraint[/!] 
CHECK(NOT (Col1 = 'Value' And Col2 Is NULL))

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[sqlval]

Thank you. Will try if it works.