SQL/ordering data based on a computed result/stored procedure?

["Reeve Fritchman" <reeve@xxxxxxxxxx>]

This is a multi-part message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
I need to display data in ascending order where the key field (price) is
dynamically computed.  I can do this with the QLGSORT API’s and I can do it
with funky RPG; I’m wondering if I can do it with SQL and stored procedures,
or something of that ilk.

“Price” is a function of the item’s base price and the current incentives
(discounts) in place for that customer/product line combination; the actual
incentive is determined from a complex set of business rules.  Therefore, a
$100 item with a 20% discount (net $80) becomes less expensive than a $90
item with a 10% discount (net price $81), and I’d like the $80 item to show
up before the $81 item.

So, SQL reads a group of items, applies a function to the item base price,
gets a “net” price, and presents ordered-by-net-price data into my
application program.  It seems simple enough…

No green-screen, client/server, or CFINT opinions are required!

Thanks,
rf


--