Return multiple Wildcards from one filed

[mwscott1]

I am able to return one wildcard value, but can not figure out how to return multiple wildcard values from one field. This is what I have and it returns all entries with "PAN" in the PART_DESC field. I also need to return values for 'DEL*' and 'LENO*'.

LOAD ORDER_DATE,

     ASSET_NO,

     SERIAL_NO,

     PART_NO,

     PART_DESC,

     ASSET_LEASE_END_DT,

     FLEX_FIELD_1

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

WHERE PART_DESC LIKE ('PAN*');

[sunny_talwar · Accepted solution]

May be using WildMatch:

LOAD ORDER_DATE,

     ASSET_NO,

     SERIAL_NO,

     PART_NO,

     PART_DESC,

     ASSET_LEASE_END_DT,

     FLEX_FIELD_1

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

Where WildMatch(PART_DESC, 'PAN*', 'DEL*', 'LENO*');