| Subject | can i use UDFs with CHECK constraint (trigger) ? | 
|---|---|
| Author | Kamlesh | 
| Post date | 2004-03-17T18:58:45Z | 
dear friends
i m having many fields in many tables which are required to have some
minimum length strings
so i thought to define DOMAIN for such kind of field, like following
CREATE DOMAIN CODENAME VARCHAR(50) CHECK ( strlen( Value ) > 5 ) );
but it generates error,
is there any way to use UDFs in CHECK constraints , so that i dont have to
write same code in all triggers
Thanks
Kamlesh
            i m having many fields in many tables which are required to have some
minimum length strings
so i thought to define DOMAIN for such kind of field, like following
CREATE DOMAIN CODENAME VARCHAR(50) CHECK ( strlen( Value ) > 5 ) );
but it generates error,
is there any way to use UDFs in CHECK constraints , so that i dont have to
write same code in all triggers
Thanks
Kamlesh