On 2013-02-01 10:18 PM, hsv@stripped wrote:
>>>>> 2013/01/31 22:24 -0600, Peter Brawley >>>>
> Is this what you mean?
>
> Select,
> pricelist
> If( !IsNull(specialprice) And specialprice < unitprice And CurDate() Between
> startingDate And endingDate,
> specialprice,
> unitprice
> ) as used_price
> >From catalog
> Where itemid='WB314';
>
> PB
> <<<<<<<<
> Maybe this is gilding the lily, but if "specialprice" is null, then
> specialprice < unitprice
> is not true
Read again: ...If( !IsNull( specialprice )...
PB
> --and maybe if the null-test is left out it is less clear....
>
>
