Using like on a result string

I need to search multiple fields from 2 joined files. (there may not be a
record in 2nd file)

I am concatenating all the fields together and separating them with a
delimiter of | eg.

Is there a way to do a Like '%string%' on the result or do I have to get the
string and then do a %scan on the string after it is fetched.

I may have more than one string to like or %scan on. There are about 100k
records in the file.



dcl-ds DATA;

ItmString char(434) pos(1);

ItmNum char(20) pos(435);

end-ds;



I'm thinking it would be faster if the SQL handled it, but I may be wrong.



Select

trim(a.ItmNum)||'|'||

Trim(ItmDsc)||'|'||

Trim(Vendor)||'|'||

Trim(VnCode)||'|'||

Trim(VnItmD)||'|'||

Trim(CsDmti)||'|'||

Trim(ItmSeq)||'|'||

Trim(ItmSq2)||'|'||

Trim(ItmUpc)||'|'||

coalesce(trim(It60Ds),'-----')

name, a.ItmNum

FROM ItmMst a left Outer Join ItmAds b

On a.ItmNum = b.ItmNum


order by a.itmnum,b.itmnum



Thank you,



Craig