ALLBASE/SQL Reference Manual (36216-90216)

Chapter 9 271
Search Conditions
IN Predicate
If the indicator variable is >= 0 and PartNumber is one of '1123-P-01', '1733-AD-01', or
:PartNumber, then the predicate evaluates to true.
If the indicator variable is < 0, the rows containing the part numbers 1123-P-01 and
1733-AD-01 are selected; but no rows will be selected based upon the value in
:PartNumber.
EXEC SQL SELECT PartNumber
FROM PurchDB.Parts
WHERE PartNumber
IN ('1123-P-01', '1733-AD-01', :PartNumber :PartInd)