Re: if statement inside function

I think you can rewrire your where clause as

where ( range_id = 1 and minimum_wage_variation_id < 100) or ( range_id <> 1 and minimum_wage_variation_id > 100)

HTH -- Mark D Powell -- Received on Wed Feb 15 2006 - 19:32:53 CST