>>>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 it's numeric don't use quotes...
>
>No, INLIST can't work within a string.
>
>The INLIST syntax is usually IF INLIST(gcMonth,'January','February','March'). I just mentioned it to show the result I wanted to get.
I think I see. No, I don't think you can use Inlist like that. You might need to parse your string up between commas to get an accurate check using ATC, maybe.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.