Information générale
Catégorie:
Codage, syntaxe et commandes
>>>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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement