Find text in text string using value list

[Jerry100]

I have inherited a database with six text fields each of which can have one of 30 two letter values. I would like to combine (concatenate) the values for each record into a new field and then perform a find for a specific value within the newly constructed field. I am not sure if one of the FM Text Functions can search a string and find a pattern. Any help would be appreciated. I may be wrong but this seemed a better option than constructing a dynamic find on each of the original six fields.

[comment]

Why do you keep six similar fields in the same record, instead of six related records in another table?

[TheTominator]

If I am understanding your requirement, I think you want

not IsEmpty(FilterValues(

List(field1;field2;field3;field4;field5;field6);

"AB")

to return a true value if the code "AB" is in one of the six fields.

If this isn't exactly what you seek, maybe it will get you closer.