--- "A. R. Van Hook" <[EMAIL PROTECTED]> wrote: > I have been trying to do an 'or' function such that if a field value > is > zero then use 1 as a multiplier: > "select sum((1 | i.count) * s.cost) as COST ...
try "select sum( (case when i.count=0 then 1 else i.count end) * s.cost ) as COST ... __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
