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.

[mendhak]

Go to your SQL Server books online, and check out CAST AND CONVERT.

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\tsqlref.chm::/ts_ca-co_2f3o.htm