At 05:17 PM 1/28/2009, Stricker, Scott wrote:
PROJ tTBLTEMX FRO TBLTEMP USI ALL WHE CATE=CONT OR CATE=REC OR CATE=LRP + AND CODEE = .VCOD ORDER BY REMDAT=ASC
Use must use database CHARACTER settings for QUOTES when comparing or providing TEXT values on the right side of the equation, such as "=". Try the following, assuming your database character settings are set to double quotes. PROJECT tTBLTEMX FROM TBLTEMP USING ALL WHERE + CATE = "CONT" OR CATE = "REC" OR CATE = "LRP" + AND CODEE = .VCOD ORDER BY REMDAT ASC OR PROJECT tTBLTEMX FROM TBLTEMP USING ALL WHERE + CATE IN (CONT, REC, LRP) + AND CODEE = .VCOD ORDER BY REMDAT ASC Hope that helps! Very Best R:egards, Razzak.
