<< My suggestion would be to avoid the null value by setting the default value to 0 . I assume the lowprice never will be really 0.00 (for free),
Then you can avoid the complicated if-statement >> If there were really no difference (to the application) between $0.00 and NULL I wouldn't have this problem. But there are some (rare) cases in which the LOWPRICE really is $0.00 (that is, it really was free) and I need to evaluate those differently from cases in which no LOWPRICE was ever entered. -- Larry
