user2680039 user2680039 - 1 year ago 77
SQL Question

Limit a table's cell's values to two values?

I have a two-column table but I want all values in the first table to be either X or Y, and no other input should be allowed. How can I enforce this?

Answer Source

You can use a validation rule.

Restrict data input by using a validation rule

A Validation Rule on the column as follows will work.

="X" Or ="Y"
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download