I’m brand-new to TOAD for Data Analysts.
I can’t get a very basic REPLACE function to work. I keep getting this error: “[Microsoft][ODBC Microsoft Access Driver] Undefined function ‘replace’ in expression.”
Entering the exact same query directly in Access works fine.
I’m using TOAD for Data Analysts v184.108.40.2063 on Windows. I’m connected to an Access database.
custnum as “Customer #”,
custaddress as “Original Address”,
replace(custaddress, 'S. ', 'South ') as “Updated Address”
I’ve hunted all over the place online to try to figure this out. What am I missing…???