I am using ADO OleDBProvider to connect to Access and SQL Server.<BR>The following query does not work when connecting to Access:<BR>Select * from Table1 ORDER BY REPLACE(Field1,&#039;-&#039;,&#039;.&#039;)<BR><BR>The error is "Undefined function &#039;Replace&#039; in expression".<BR><BR>The same statement works inside Access Query but fails when passed as a record source to ADO recordset.<BR><BR>Can someone show me how functions can be used in a select statement connecting to Access?