[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Find records that has all items in the list

[jonathan.wilson]

So the following is the MATCHES stuff in a quick example... again this only works if you sort your "ABC" data in the string on both and the identifiers are unique. DEF TEMP-TABLE ttData NO-UNDO FIELD c_code AS CHAR INDEX idx1 c_code. FUNCTION CreateTT RETURN LOG (INPUT c_data AS CHAR): CREATE ttData. ASSIGN ttData.c_code = c_data. END FUNCTION. CreateTT ("A,B,C"). CreateTT ("A,C"). CreateTT ("A,B,C,D"). CreateTT ("C,A"). FOR EACH ttData WHERE c_code MATCHES "*A*C*": DISP ttData. END.

Continue reading...