help on function like 'find'

[tulip]

Hi, pros:

Here is the statement as follows:

where find(concept, 'Condition1','i')>0 or find(concept, 'Condition2','i')>0

however, I would like to like conditions to be listed in the following way conceptually so that it is easier to manage plus achieving the find function.

where id in ('A', 'B', 'C');

Your help is appreciated so much. Tulip.

[Doc_Duke]

To use the simple syntax of the IN operator means that you have to pre-process your data to pull the conditions of interest out of the concept variable. It is really a case of 'pay me now or pay me later', at some point you have to parse the variable concept.

TANSTAAFL