IBM Mainframe Forum

Peter_Mann wrote:I didn't interprite the OP's question that a wilcard seach or a seach in the middle of a field was what was needed

But heesh quite explicitly wrote:

I can't use TBSCAN since RED would not match "BLACK WHITE RED BLUE"

How can this be interpreted as other than a request for a way to search for a token within a column?

Well, guess my interpitation if what the OP wanted is quite different, if I wanted to scan my table for all ROWS that match RED, I scan that KEY for...... RED, I guess I over simplify the OP's requrement.

Pedro is right. I need to find a value anywhere in the field. The value can have 3 words for example, and I want to be able to find it in any word position.