Re: how can i put multiple statmwnts in sum(case...

From: Totti <>
Date: Sun, 6 Jan 2008 07:06:08 -0800 (PST)
Message-ID: <>

Thank you Mr. D.A. Morgan

i am sorry, i didnt make my self clear, it was my fault , the way i wrote the procedure; i meant to say :

if ('base' and 'east') --> 1.5%,
if ('base' and 'west') --> 2.2%,
if ('base' and 'north')--> 0.95% .....

else 0 end.
and so on so forth,
than add % s under 'base' to get the final amount paid for carrying it, since the fee is a percentage of the sales. the reason i want to use case is because i thought it might do my job since i wanted to do the math of all these percentages and i thought that sum of case would be a good approach. Received on Sun Jan 06 2008 - 09:06:08 CST

Original text of this message