Greetings. I am using VB6 to retrieve data from some foxpro tables as follows.

Dim cnCompany As New ADODB.Connection
Dim RsExport As ADODB.Recordset

strSQL = "Select price from Products"
Set RsExport = cnCompany.Execute(strSQL)

This works fine, but I would like to format the price. I have tried various including...

strSQL = "Select format(price,'0.00') from Products"
Set RsExport = cnCompany.Execute(strSQL)

but it gives the error message
format.prg does not exist

Does anyone know what will work with ADODB?