[Stackoverflow] [Progress OpenEdge ABL] Progess 4GL - How to filter multiple records using AND operator in one table field?

[Bharat]

I want to check and filter only if the table has value1 = 005 and value1 = 009. But it seems below query is helping me. I dont know where I am making mistakes. Kindly help to solve this.

DEFINE TEMP-TABLE test NO-UNDO
FIELD value1 AS CHARACTER
.

EMPTY TEMP-TABLE test.

CREATE test.
ASSIGN
  value1 = "005".

CREATE test.
ASSIGN
  value1 = "009".

CREATE test.
ASSIGN
  value1 = "001".

FOR EACH test NO-LOCK
   WHERE value1 <> ""
   AND (value1 = "005" AND value1 = "009")
  :

   MESSAGE YES.
END.

Continue reading...