boolean in caluclations

how can i do this in pl-sql?

when lines=2 that is replaced by a 1 allowing that math to take place

when lines>2 it adds the other piece instead. Trying to avoid if statements.

fee := (fixed_mf + ((lines=2)* lines_2) + (((lines>2)*(lines-1))*lines_more));

thanks for any help or information. Received on Tue May 29 2007 - 14:40:09 CDT