| Subject | Re: [firebird-support] Value check that I don't now how to solve |
|---|---|
| Author | Alex Taylor |
| Post date | 2003-11-30T21:11:32Z |
Yes, You really don't need an UDF for this. Markus is right.
Do the following:
CREATE DOMAIN quarter_ AS
DECIMAL(18,2)
NOT NULL
CHECK ((VALUE*4)-CAST((VALUE*4) AS NUMERIC(18,0))=0)
Regards:Alex
Do the following:
CREATE DOMAIN quarter_ AS
DECIMAL(18,2)
NOT NULL
CHECK ((VALUE*4)-CAST((VALUE*4) AS NUMERIC(18,0))=0)
Regards:Alex