Thread When the MYOB Retail Manager adaptor is being used to export product data from Retail Manager's underlying database, there was a requirement to replace the space characters in the product's description with dash characters when being mapped to the "SEO Item ID" field. The problem is that when the database that Retail Manager's data lives within is an older version of the Microsoft Access database, the ODBC driver used to obtain the data does not support the REPLACE function in SQL queries, which makes it impossible to replace characters with other characters.

---

TOTECS Software Development Manager