We've migrated to MX recently and discovered that when selecting against Access DB using LIKE it no longer works.
The code concerned is
<CFSET searchCriteria = "WHERE #CHR(34)#Postcode#CHR(34)# like '%#Area# %'">
The following syntax error is reported.
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in query expression '[Postcode] like ''%EH1 %'' AND [Available] = -1'.
This could used to work before upgrade to MX.
I've tried a numbner of quote combinations but none are successful.
Does anyone have any idea if the LIKE syntax should be properly used in MX?