I am querying a excel file USING A EXCEL Macro. I populate an ADO recordset with a SELECT statement ,so how can I limit the number of decimal of the data retrieved from excel file, for instance:
excel data
--------
12.3654
11.369
25.125
14.7521
retrieved data
------------
12.37
11.37
25.13
14.75
"SELECT buy FROM employes WHERE id=12".
Is there some way to do it directly in the command line "SELECT" ..?
Bookmarks