Format in SQL Server

[eimroda]

I am new to SQL Server. I have a program that uses MS Access 2000 as its backend db. In one of my SQL statements, i have this:

SQL = "Select Format(UPrice,'###,##0.00') From tblPrices"
rsPrice.Open SQL, Conn, adOpenForwardOnly, adLockReadOnly

It is working fine with Access. As we upsize the DB to SQL Server, I am getting then with an error with the SQL statement. Pls help me to convert that to a statement that is compatible with SQL Server 7.