Undefined Function ‘CHARINDEX’ in expression’ Error
Posted on 2007-03-21
I need your assistance. I have the following SQL that works in SQL Query Analyser but it is not working on MS Access on the SQL section.
I received the following error:
Undefined Function ‘CHARINDEX’ in expression’
How could I fix this error? Can any one assist please?
SELECT A.DOCID AS 'Product ID',
A.ProductCategory AS 'Product Category',
B.DOCID AS 'Sales ID',
B.SalesCategories AS 'Sales Categories',
A.ProductAvailability AS ' ProductAvailability '
FROM Product A,
WHERE A.DOCIDPP = B.DocID
AND CHARINDEX(A.ProductCategory,B.SalesCategories) = 0