Ya like Yahweh said, it's a data type problem that is not in string form but another, and while displaying it on page, vbscript plays the unnecessary role, if you convert that data type to sting, it will display correctly.Better if you cast your variable into string while opening a recordset. <%Dim objCon, objRs , strSqlSet objCon = Server.CreateObject("ADODB.Connection")Set objRs = Server.CreateObject("ADODB.Recordset")strSql = "SELECT CAST(myCurrencyField AS VARCHAR(20)) AS myCurrencyField FROM myTable"objCon.Open "Provider=SQLOLEDB.1..........your connection"objRs.Open strSql, objCon' this will display your currency field accuratelyResponse.Write "<b><u>Currency</u></b>" & "<br><br>"Do Whie Not objRs.Eof Response.Write objRs("myCurrencyField") Response.Write "<br>" objRs.MoveNextLoop%> Try out this also