Let's take it a step further,

Suppose I have a select statement like:

select (number*price) * iff(type = "BUY", 1, -1) as costs from TABLENAME


It won't work with using:
SELECT TRANSFORM(number*price, "999999.99") AS costs

any other suggestions ?

John