I am trying to filter on a field that is 260 characters and is filled with concantenated values of a code. There can be one or many codes in this 260 character field.

I have used a statement of:

*WHERE ( SBDIS LIKE '%D30600%' OR '%D30602%' OR '%D30614%' OR '%D30616%')

to find specific intances of codes within this field.

and I have seprately used a statment of:

WHERE B593KEY_13 IN FILE 13BTN

to find a match between the field and a file that has a collection of values I am looking for.

Is there anyway to do a combined "in file" with wildcards? Something like:

WHERE %SBDIS% LIKE IN FILE 13BTN

What I need to find is a set of records where SBDIS contain any of a list of 150 specific codes. I would like to use a file to lookup those values instead of hardcoding them into a statement like the first one.

Any suggestions?

I would use Dialog Manager to read the values in the file and create the selection criteria. Here's a working example:

-SET &ECHO=ALL;

FILEDEF FMTEST1 DISK EQP/FMTEST1.TXT
-RUN

TABLE FILE CAR
PRINT COUNTRY CAR MODEL BODYTYPE 

WHERE
-READ FMTEST1 NOCLOSE &SELECTION.A03.

-REPEAT ENDREP1 WHILE &IORETURN EQ 0;
-TYPE &SELECTION
BODYTYPE LIKE '%&SELECTION.%' OR
-READ FMTEST1 NOCLOSE &SELECTION.A03.

-ENDREP1
BODYTYPE EQ ''
WHERE BODYTYPE NE ''
END
-RUN

Change the FILEDEF to point to a file in one of your app directories. My selection file has these two values in it:
SED
ROA

The line BODYTYPE EQ '' is there to complete the series of OR statements generated by Dialog Manager.
The line WHERE BODYTYPE NE '' is to negate the previous selection (BODYTYPE EQ '').

Run the code and then view the HTML source to see what's generated.

Cheers,

Thanks for the idea. I am still working on getting this to work for my situation, but your suggestion did point me in the right direction. If I ever get the code to do what I need I will post it.