Des2000: using functions in domains

Using Designer 2000, I'd like to be able to define a domain called VALID_DATE. The VALUE attribute of allowable values would be a constant, but the HIGH_VALUE would be the function sysdate.

When you generate the SQL DDL for a table using the VALID_DATE domain, the resultant check constraint puts single quotes around sysdate:

CHECK ( <column_name_here> BETWEEN '01/01/1901' AND 'sysdate' )

Obviously, one could go in and manually remove the single quotes from the DDL, but that defeats the purpose of designer. Is there a way to use a function as an allowable value?

Since I'm on the allowable values topic, is there any way to define HIGH_VALUE without specifying VALUE? (ie I don't want to define a range of values; rather, I want no lower bounds only upper bounds)

Thanks in advance,
-Matt

-- 
Matthew G. Stahl  | EMail:  mgstahl_at_sonalysts.com
Analyst           | Voice:  (860) 442-4355 x 112
Sonalysts, Inc.   | Fax:    (860) 442-5080


=================================================

All opinions expressed are purely my own and do  
not reflect those of Sonalysts, Inc.


=================================================