>>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.