>>>I have a TEST field which contains something like 1,2,5,18,23,32,33,34.
>>>
>>>I would like to compare a value within this field value.
>>>
>>>For example, I would like to do something like
>>>
>>>IF INLIST(TEST,'23')
>>> ...
>>>ENDIF
>>>
>>>But, this is not working. How can I process this validation?
>>
>>if ",23," $ ","+alltrim( TEST)+","
>>...
>>
>>This the best way I know. Please note that it's very important to add commas before and after TEST (otherwise you can find 23 in 423 for example even if 23 is not there). A good idea is to keep ",1,2,5,18,23,32,33,34," in TEST, not "1,2,5,18,23,32,33,34". It's faster.
>
>That will work but not if 23 is at the beginning or at the end.

Sure it will work. Vlad put the necessary "," at both the beginning and end of the string. If they're already in the string, no harm done.

Barbara