Query for this pricing model

[ChrisFarrugia]

Dear All, I am implementing a shopping where the prices of the products are structured according to the quantity taken for examle: 1 = 1 Euro 3 = 0.80Euro 5 = 0.70 Euro etc etc The database is structured as follows: quantity1 pricequantity1 quantity2 pricequantity2 quantity3 pricequantity3 etc A quantity and pricequantity can be set to 0 if no further quantity groups exist. I need a query where I pass a quantity and it gets the subtotal. Can someone help please? Thanks Chris

[Christian Graus]

I guess you can put a case statement in your select.

Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )