Error When Using REPLACE In SQL
Posted on 2008-06-23
Hello. I am Connecting to an Access db via ODBC. I am using PHP to display my results, but I can't get the SQL REPLACE function to work. If I were using MySQL, I would put the following into my select statement:
" REPLACE(permits.Date,'00:00:00','') as 'Date' "
When I try to put that into the sql that hits the access db, I get this error:
"The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect., SQL state 37000 in SQLExecDirect "
What am I doing wrong? Thanks a lot.
What type of SQL am I using when I'm connected to an Access db through ODBC?