Re: Check Constraints

this could be a bad solution, but yet if nothing else works try the on insert trigger to check the value that you are inserting...

take care
atul

casper44 wrote:

> How do I check to make sure a attribute of type VARCHAR2 is greater
> than 2 characters? For example if I create a table and the attribute
> is:
>
> organization VARCHAR2(50) NOT NULL,
>
> and I also want it to always be greater than 2 characters.
>
> Thanks.

--

Atul Agrawal                     | Atul Agrawal
Masters Student, CS Deptt.       | 3501, St Paul Street,
Johns Hopkins University         | Apt # 1018,
3400, N Charles Street, NEB 224  | Baltimore,
Baltimore, MD 21218.             | MD 21218.
                                 |
Hello: 410-516-8291 (Lab)        | Hello: 410-366-6852 (Resi)