I'm using odbc to connect to an Access dbase and executing the following php command:
PHP Code:
$ctrquery = "SELECT * FROM Contractors "; 
this works fine and records get selected but when i change it to use the replace function:

PHP Code:
$ctrquery = "SELECT *, Replace(tel_no, ' ', '') FROM Contractors "; 
no records get selected. Has anyone had the same prob or knows why this is happening?

The replace function works in MS Access!!!!

Any ideas????