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??