Try using SELECT TRANSFORM(number*price, "999999.99") AS costs ...
This is not the *correct* way of doing it but, as long as you don't have large amounts of data to select from, it should be sufficient.
>Hello
>
>I have a select statement:
>
>select (number * price) as costs from TABLENAME
>
>I want price to be in the format like:
>####,## So 2 places after the comma. Can i define a datatype
>for Costs somehow ?
>
>Thanks