FORMAT function in SQL Server 7 - HELP!!!

[Jimbob]

What's the equivalent of the FORMAT function in SQL Server 7.

I'm converting an older app from DAO, and sometimes comes up with a query that includes the following: -

Format(ROUND(([GrossPrice]+[Tax]-((([GrossPrice]+[Tax])/100)*[Commission])),2),'0.00') AS Net

but SQL Server doesn't like FORMAT...

[Mongo]

In Sybase you'd use:

convert(money, ([GrossPrice] + [Tax] - ([GrossPrice]+[Tax]) / 100) * [Commission])) AS Net

But check your MS SQL Server refs for the specifics on the CONVERT function.





[Edited by Mongo on 07-01-2000 at 01:17 AM]

In SQL Server(6.5 or 7.0) you could use CONVERT or CAST.