I should have added that I was using the ODBC driver to a MS Access database. This was not a mySQL database.
Thanks
I missed that detail in the error message.
However, I'm pretty sure those functions are generic enough sql functions that they should work in an ODBC connection. If I'm right, then the ODBC driver should convert it to the proper syntax for Access.