On 11 May 2006 at 7:04, majstoru wrote:

>I think that CASE will solve this but, can I use multiply CASE into
>one SQL statement and if I can, what is sintax?

I would use many joins to calculate all variants of price at once
and then CASE to choose needed... Or one SP.

--
SY, Dimitry Sibiryakov.