系统移植,这条sqlserver中的语句怎么移植到access中
"select wz_lmid,x_fulan,x_lmmc,x_lmbm,x_lianjie from wz_lm where charindex(x_lmbm, '"+session("Right")+"')>0"
出错说
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Undefined function 'charindex' in expression.