Query Sage Database

  • Thread starter Thread starter Dave Bradshaw
  • Start date Start date
D

Dave Bradshaw

I am trying to construct a query that will return all the part numbers
that don't begin with a "Z" from a Sage Accounts database. I thought
it would be straightforward to just put
Not Like "P*"
in the criteria cell, but when I do I get an error:

ODBC call failed
Syntax Error: Invalid filter in WHERE clause (#0)

I suspect this is due to a problem with the Sage ODBC driver. Can
anyone confirm that this is the case, and can anyone suggest a work
around.

Thank you

Dave Bradshaw
 
Dave said:
I am trying to construct a query that will return all the part numbers
that don't begin with a "Z" from a Sage Accounts database. I thought
it would be straightforward to just put
Not Like "P*"
in the criteria cell, but when I do I get an error:

ODBC call failed
Syntax Error: Invalid filter in WHERE clause (#0)

I suspect this is due to a problem with the Sage ODBC driver. Can
anyone confirm that this is the case, and can anyone suggest a work
around.
Click to expand...

It might be the asterisk (*) wildcard character. Try the percent sign
(%) instead of the asterisk as the wildcard character.
 
Back
Top