Skip to Content
Former Member
Oct 07, 2005 at 05:53 PM

Query Error


I used to have the following query in version 2004a and it work fine (and it still does on that version) , know we did the RamUp to the version 2005A and it gives me this error : Incorrect Syntax Error on 'Value of the parameter that I typed'

The query is the following:

SELECT T0.ItemCode, T1.Substitute, T0.ItemName,T2.CardName, T0.OnHand

FROM OITM T0 LEFT JOIN OSCN T1 ON T0.ItemCode = T1.ItemCode LEFT JOIN OCRD T2 ON T1.CardCode = T2.CardCode WHERE T1.Substitute like '[%0]%%' OR T0.ItemCode like '[%0]%%'

Any Ideas?? Did something change on Version 2005??