General information
Category:
Coding, syntax & commands
>>>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.
Why not?
Vlad
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only