Hi Thomas That CHECK() wouldn't be needed at all, would it?
/gustav >> txr_rate decimal(5,3) not null , >> CONSTRAINT ckc_txr_rate_txr CHECK (txr_rate <= 100 ), > The problem is the value of 100 which does not fit into a number having 2 digits > to the left of the decimal point (txr_rate_rent decimal(5,3)). > Please change the constraint ckc_txr_rate_txr to > CHECK (txr_rate <= 99.999 ) _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
